Queries based on query

[jorisam_]

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

[v-juanli-msft]

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.

[amitchandak]

@jorisam_ ,Not very clear

refer

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

https://community.powerbi.com/t5/Desktop/parameterize-connection/m-p/205900#M90712

[Fowmy]

@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 🙂

YouTube, LinkedIn