Power BI service not updating queries in PBIX

[JeffManley]

I have 97 queries defined in a PBIX that is published into a workspace on Power BI service. I'm pulling data from various APIs (Salesforce, Outreach, Sendgrid, Chorus, Lever, Jira) and some Excel spreadsheets. I just noticed that the Power BI service is no longer automatically refreshing the queries and I'm receiving the following error:

This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources.

• Data source for Query1

I have searched through the 97 queries in the advanced editor and cannot locate "Query1". How can I determine which query is causing the problem?

[nitishsh91]

Hi @JeffManley 

It looks like you are using Web.Contents and creating a dynamic url which is not supported by default to be refreshed , you will have to make some amendments in your report, here is the link that suggests the changes that can be made:

https://medium.datadriveninvestor.com/setting-a-scheduled-refresh-on-a-dynamic-data-source-in-power-...

Let me know if this doesn't help will share a more working example but in short you will have to make your url in 2 parts: Web.Contents("Base Address ", [RelativePath="the rest of api call parameters"])

[JeffManley]

Hi @nitishsh91 

Thanks for leading me in the right direction. I've made the recommended change to use the RelativePath= and the BI Service now tries to run the refresh (without a gateway - since these are web API calls). However, I've run into another error when attempting to do the refresh on the Power BI Service:

"Processing error[Unable to combine data] Section1/OutreachMailings/Source references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."

I've made sure that privacy is set to Organizational (even tried Public) on the dataset and have even selected the option to ignore it. The Outreach API requires two steps to authenticate (OAUTH2) which I've created in M code. It works fine on the Desktop but seems that the Power BI service does not support it. Would you happen to have a solution for this?

Thanks,

Jeff

[bcdobbs]

I've had a similar error in data flows so hoping the solution might be the same. I find the solution has always been to make sure the queries that under pin the ones down the line are set to not load. If you do need them loaded you can reference the not loaded ones to materialise them.

[GilbertQ]

Hi @JeffManley 

From my understanding Query1 is often the first or second table when you open Power Query?

If that does not work what you will have to do is delete a bunch of tables. then go into data source settings and see if the warning for "Hand Authored Queries" is no longer there. Once it is no longer there you then need to delete a table at time to find out which one is causing the error.