We have created a dashboard that refreshes from a webi report.
Users will access the dashboard on a website, not through BI launchpad.
When the dashboard it loads it tries to refresh from the report, and presents users with enterprise login screen.
I understand that to stop this I need to hardcode the username and password into the excel sheet that is read by liveoffice/webservices connection.
I don't want to hardcode any sensitive information like this and would rather the dashboard did not show the screen.
What options do I have?