Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 issue. However, when I publish this and attempt to set up a scheduled refresh, I get an error saying I need a gateway. This is unexpected, since the data is on a publically accessible website. My understanding is that a gateway is only required when accessing data on premises or where some kind of firewall is in place - not something we have in this case.
Any suggestions in terms of how to get around this issue?
A copy of the report is available HERE should anyone wish to test this. Simply click the download link at top right to get the file downloaded.
Solved! Go to Solution.
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! 🤯
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! 🤯
Good to know
Thank you too
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @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...
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi aj1973 - see my solution posted above. Thanks for your response.