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
KBO's avatar
KBO
Icon for Memorable Member rankMemorable Member
6 years ago

Hi Anonymous ,

normally the WebURL dosn't need any credetials it works with annonymous. May be you try another connector for your case. Do you need for the Web URL your credentials to log in? May be you should connect to the database behind the  website If its your data you need to use?

 

Best,

Kathrin

 

 

 

 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

  • 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