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 dat...
Anonymous , see, if the blog on a similar topic can help
https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78
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.
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