How to extract from a URL API using a table as part of the URL parameter?

[Anonymous]

Hi Guys,
My issues is exactaly as the Subject: How to use PowerBI to extract from a URL API using a table as part of the URL parameter to create a single file with all results?

In my scenario, I have:

1) A .csv table (actually a single column named "M_ID") with 7K rows;

2) An URL, that return a json.

Part of this URL is the column "M_ID", something like this: http://lorem.ipsum/"M_ID"/true/out=json
I need to extract from the URL all json returns and create a single file.

Is it possible to do this with PowerQuery?

I don't know if I was clear, if not let me know.

[v-lili6-msft]

hi, @Anonymous 

You may refer to these posts:

https://community.powerbi.com/t5/Desktop/How-to-setting-a-dynamic-URL-connection/td-p/57072

https://community.powerbi.com/t5/Desktop/Passing-a-parameter-to-a-URL/td-p/103363

Best Regards,

Lin