Forum Discussion
Queries based on query
Hi everybody,
I'm new and i'm trying to use PowerBI for making a report.
I need your help.
I try to show statistics for each email campaign. These stats are avaible using an API.
The problem is : there is one API showing the list of the campaigns sent with their code.
Then I have to make a request base the code for obtaining the statistics of each campaign.
How can PowerBI do that automatically ?
I know how to show the list of campaigns but i don't know how to tell POwerBI that it has to lauch X queries base on a url/API ("wwwYYYY.com/API/CAMPAIGNNUMBER) where CAIMPAIGNNUMER is different for each row...
Thanks
3 Replies
jorisam_
Not sure if you have a problem getting the data from the web source based on parameters.
https://docs.microsoft.com/en-us/power-query/power-query-query-parameters
Can you explain more about the issue you are facing?________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
Hi jorisam_
Create a table with different CAMPAIGNNUMBER, if it is of number type, you could do like this in Advanced editor:
let source={1..100} in sourcethen convert it into table.
Create a function with parameter like this thread:
https://community.powerbi.com/t5/Desktop/script-running-looping-URLs-and-get-data/td-p/135980
Then invoke the custom query(Add custom column->invoke custom function) into the first table you created.
If you have any problem, feel free to let us know.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
