dynamic data source error

[Anonymous]

Hi,

I am trying to fetch data from bitbucket website using their APIs. In my project I have roughly 500 repositories and for each repository I am trying to pull commit, merge information etc.

To achieve this, I have written a function in M query (which sort of behave likes a for loop), what it does is, it takes repository name as a parameter and fetches the information for that repository. This function is applied to all the repositories. The code runs without error in my desktop but when I push it to powerbi service, it throws an error, saying dynamic data source can't be refreshed in service.

I will be really greatful if someone could help with this.

[Anonymous]

Hi @Anonymous 

I searched in Forums and found some similar issues ,maybe you can refer to it .

https://community.powerbi.com/t5/Power-Query/REST-API-Dynamic-Datasource-aren-t-refreshed/m-p/1811650

https://community.powerbi.com/t5/Service/This-dataset-includes-a-dynamic-data-source-Since-dynamic-data/m-p/1694170

https://community.powerbi.com/t5/Power-Query/Dynamic-data-sources-aren-t-refreshed-in-the-Power-BI-service/m-p/1563630

Best Regards

Community Support Team _ Ailsa Tao

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

[ibarrau]

Hi. This issue can not always be solved. Let see if we are able to fix yours 🙂

The most important thing when taking a lot of requests from API is the way you structure the request. In order to help Power Query understand which is the data source you need to have the same URL in the Web.Contests for all the requests in every row. You can do that applying the following best practice (url, relativepath, query):
https://blog.ladataweb.com.ar/post/630597294839955456/powerquery-buena-práctica-para-un-web-request

If you organize the request like that Power Query might be able to help you discovering a unique data source avoiding the dynamic source.

That can fail if you have a really complex request or API.

Let us know if you can solve it. We can help more if you share the PQ code of your request.

I hope that helps,