Dynamic web datasource connection

[Anonymous]

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. 

[v-henryk-mstf]

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,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , see, if the blog on a similar topic can help

https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78

[Anonymous]

We are not looking for a paginated report. We want the parameters in the list (i.e the URL along with the customer ID)  to be passed one by one dynamically to the data source connection. 

Could you please suggest on it. 

[amitchandak]

@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

https://hatfullofdata.blog/power-query-fetch-web-data/