Forum Discussion
Dynamic web datasource connection
Hi Team,
We are fetching data from a Web API. We have 1000 customers and we can get the data for each customer by appending the customer ID to the URL at the end. This way we need to get the data for 1000 customers.
For this we loaded the complete URL (i.e the base URL + different customer ID's) into a parameter and gave this parameter to the data source connection, but this is not working.
It is working fine when only one URL is given as parameter to the data source connection.
Can you suggest, how can we loop through the next item in parameter to the same data source connection.
4 Replies
Anonymous , see, if the blog on a similar topic can help
https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78
Anonymous , I think that was how to create pagination in the power query. Means get multiple value
Another option is a list of values passing to url
https://community.powerbi.com/t5/Desktop/How-to-setting-a-dynamic-URL-connection/m-p/57072
Hi Anonymous ,
I think the link amitchandak provided is worth referencing. If the problem persists, please point it out specifically and I will answer it for you as soon as possible.
See also a similar solution.
Solved: Create Dynamic parameter to load data in Power BI - Microsoft Power BI Community
Best Regards,
HenryIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
