Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
82 | |
67 | |
61 | |
46 | |
45 |