Forum Discussion
Silviooooooo
Apr 22, 2021Copper Contributor
Power query - Use a column as url for API call
Hello all, First of all, thank you for your time in helping people like me who need help. I have been banging my head on my desk since monday on this issue. I am an author on a website that write n...
SergeiBaklan
Apr 22, 2021Diamond Contributor
You can't combine dynamic parameter directly with URL string. Use RelativePart parameter instead, it's explained for example here https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/
Silviooooooo
Apr 22, 2021Copper Contributor
Thank you for your suggestion SergeiBaklan,
I tried to use the RelativePath parameter in my query, as shown in the blog you provided but I had no luck. The function i used was the below:
However this still returns this error message when i try to give the Column as argument in the RelativePath option :
Could it be related to the fact that the error message indicates that the " character are replaced by %22 in the url ?