Web source data credentials stuck on sign-in during edit

[bisho]

Hello,

I have a web based source that I set up on PowerBI Desktop, and it was connecting and refreshing normally on PowerBI Desktop. However, upon publishing to PowerBI Service, the web source pops an error for a data source credential failure. Upon hitting edit credentials and modifying the privacy level and permission, the sign-in just ends up stuck:

The web source is an html/php page that is accessible for my organization. When not connected to the company wi-fi and/or VPN, the page is inaccessible. I'm assuming that might play into the sign in being stuck. The website doesn't need any sign-in credentials, apart from being on the company network. I do have some read-only credentials on a .php file that I can leverage, but am unsure where to implement something like that.

On PowerQuery, only anonymous permissions are allowed for web-based sources. However, it seems like no combination of authentication methods and privacy levels work. No matter what I select, the data credentials pop up ends up stuck during sign-in. Can anyone help me resolve this matter? How can I ensure some sort of organizational check/connection before opening up the web-based source? Are there any potential workarounds? Any help is much appreciated.

Thanks,

Bisho

[Daryl-Lynch-Bzy · Accepted solution]

Hi @bisho - if you must be inside your Company's network to refresh this query, you will need to use an on-premise data gateway to allow Power BI Web Service access.  This scenario works on the same principle when Power BI access your network drives and local sharepoint. 

[bisho]

Thank you for the clarification Daryl.