Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

"Windows" Datasource Permission Allows Refresh on Desktop Cannot Refresh Report on Workspace

Hi,   I have a report that pulls data directly from a web page that we use to view historical data. The webpage allows me to download the data I want to an excel file, but this requires me to manua...
datasource
datasource error
Refresh
web source
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi KBO ,

 

Unfortunately, Power BI tells me that it cannot connect to the datasource when I use Anonymous. I don't actually have to log in to the site when I load it, but the webpage gets my Windows credentials somehow and uses that to give me access to the page (setup via SSO, I think). 

 

The webpage pulls data from our SAP database. Connecting to the OData source would be ideal, but unforunately my company's Information Systems group has a policy against giving anyone direct access to the OData, so I have to use the intermediary systems they set up to access the database. 

 

I'm just not sure why I can use the "Windows" Credentials on the Desktop file, but not on the Power BI workspace