Forum Discussion
Solved
Is Web.Contents different in Excel Power Query than Power BI? No "RelativePath"
I've been working with Power Query in Power BI and recently tried to move to Excel a function that worked fine in Power BI. The query uses Web.Contents() with the parameter RelativePath. However when...
Just tried
let Source = Web.Contents( "https://data.gov.uk/api", [ RelativePath="3/action/package_search", Query= [q="cows", rows="20"] ] ) in Source(sample from Chris Webb) it works. I'm on Power Query version
Yes, version 2.24 is quite old. On the other hand as I remember Relative Path was in Power Query for years. Perhaps some details of syntax and parameters were changed, not sure.
In general yes, Power Query is different for different branches. Excel version is some behind the version for Power BI Desktop, and within Excel is also the difference - that's end of support Power Query add-in, PQ for Mac is limited version of PQ for Excel for 365, etc.
Our devops folks upgraded that instance of Excel from 2016 to O365 (2019) and now I'm in business. My query is working in Excel as it does in Power BI. Greatly appreciate your help.
elkbane Great, glad to know you sorted this out