Forum Discussion
Solved
Gateway 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...
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
