March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I've looked through various posts and questions regarding this and have been seeing conflicting information so I wanted to reach out for a clear answer.
The data source for my report is a public website (https://www.marketindex.com.au/commodities/lithium). I can refresh the dataset fine from Power BI Desktop, but get a "refresh failed because this dataset requires a gateway" error when I try to refresh the dataset from the online Power BI Service.
Is a gateway required to refresh a web connection dataset in Power BI Service? As I had mentioned, this is a public https website. On the Power BI Data Sources page it states that a gateway is required, but I've also read various posts mentioning that it isn't (maybe they were old though).
Solved! Go to Solution.
Yes, that's the current and correct info:
https://docs.microsoft.com/en-us/power-query/connectors/web/web-troubleshoot
If memory serves, this did change several years ago so you might have looked at blog posts written prior to the change. Try using Web.Contents instead of Web.BrowserContents to avoid the need for a gateway:
https://docs.microsoft.com/en-us/powerquery-m/web-contents
Yes, that's the current and correct info:
https://docs.microsoft.com/en-us/power-query/connectors/web/web-troubleshoot
If memory serves, this did change several years ago so you might have looked at blog posts written prior to the change. Try using Web.Contents instead of Web.BrowserContents to avoid the need for a gateway:
https://docs.microsoft.com/en-us/powerquery-m/web-contents
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
39 | |
22 | |
21 | |
10 | |
10 |
User | Count |
---|---|
60 | |
56 | |
22 | |
14 | |
12 |