Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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
source
then 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.
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
70 | |
38 | |
28 | |
26 |
User | Count |
---|---|
99 | |
87 | |
45 | |
43 | |
35 |