Forum Discussion
DataSkills
Resolver I
2 years agoGateway being requested for public website
I have built a very simple report that uses the website http://www.xe.com/currencytables to get the latest exchange rates. The report works perfectly in desktop and I can refresh data without an...
- 2 years ago
I managed to get this resolved. It was a bizarrely simple fix.
My original query was as follows for the "source" step in Power Query:
= Web.BrowserContents("http://www.xe.com/currencytables/?from=GBP")
I simply amended this to be:
= Web.Contents("http://www.xe.com/currencytables/?from=GBP")
That fixed it! 🤯
aj1973
Community Champion
2 years agoHi DataSkills
Your web site is not a cloud service, it is just a Web link URL therefore you need to install a Gateway.
You don't need Power BI Gateway for Cloud Services such as Sharepoint, Snowflake, Azure...
DataSkills
Resolver I
2 years agoHi aj1973 - see my solution posted above. Thanks for your response.