Forum Discussion
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 novels and I built a dashboard with the Excel Power Query tool.
There is still one thing I can't do though, I am trying to use a text string contained in a column as argument to make an API call.
The function is the following :
When I use it with a direct text string, it works like a charm as you can see in the "Personnalisé" column below:
The only issue is that in each line of my table, i want to use a different argument (= use a different url for my API request).
I tried to use a column as argument, but after several days of hardship, i come here to ask your help. Here is what I get so far…
Thank you all very much for your help.
Have a great day !
Silvio
2 Replies
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/
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 ?
