Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |