top of page

How to avoid having to use a personal gateway for web data sources (html page or table) in Power BI

Writer: Brunner_BIBrunner_BI

When you import publicly available data into your report you will most likely use the web connector in Power Query.

This might lead to issues later on when trying to refresh your dataset.


Here is why:



When you select the Web connector in Power BI (or Power Query) to load publicly accessible data (with anonymous authentication)







This function will be automatically created:

= Web.BrowserContents("MYURL")


This will lead to issues when you publish your report to the Power BI Service and try to refresh it.



As you can see, the gateway connection option is on and data source credentials is greyed out in the Power BI service.


This means you can only refresh your data after installing a personal gateway on your machine and we do not want that.





So what can be done?


Well it is pretty easy, manually change the function to:


= Web.Contents("MYURL")


Now, when you publish your report you will see the following:


Power BI tells us this is a public data source and it does not need a personal gateway.








Now we can also set our data source credentials with the correct authentication method and privacy level.



Conclusion


Replace the default function created by the web connector Web.BrowserContents with Web.Contents as outlined above.


Microsoft's documentation states that:

Web.BrowserContents "Returns the HTML for the specified url, as viewed by a web browser."

whereas

Web.Contents "Returns the contents downloaded from url as binary"


If you have had trouble with this feel free to comment and share your thoughts.

 
 
 

4 Comments


Guest
Aug 28, 2024

Thank you so much!

Like

Marcelo Navarro
Marcelo Navarro
May 07, 2022

You are a life saver, thank you so much!

Like

ayahmsa
Aug 22, 2021

Thank you so much for such valuable info, any insight about the same issue while using sharepoint folder/url?

Like
Brunner_BI
Brunner_BI
Aug 23, 2021
Replying to

If the Sharepoint is on-prem then you need somekind of gateway to push the data to the internet somehow. If it is Sharepoint Online you shouldn't need a gateway in the first place. Can you tell me a little more?

Like
bottom of page