Refresh Schedule

[cingram11]

I am trying to schedule a refresh but see 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 gone to data source settings and see "some data sources may not be listed because of hand authored queries". How do i fix this so I can schedule a refresh?

[lbendlin · Accepted solution]

Best option: Don't have dynamic data sources with native queries

Second best: Hide the dynamic data sources from the Formula Firewall by inlining the queries into the same Power Query partition

Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Learn

[v-kpoloju-msft]

Hi @cingram11,
Thank you for reaching out to the Microsoft fabric community forum.

Has your issue been resolved? If the response provided by the community member @lbendlin, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Community Forum.

[v-kpoloju-msft]

Hi @cingram11,

Hope you had a chance to try out the solution shared earlier. Let us know if anything needs further clarification or if there's an update from your side always here to help.

Thank you.

[v-kpoloju-msft]

Hi @cingram11,

Just wanted to follow up one last time. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.

[lbendlin · Accepted solution]

Best option: Don't have dynamic data sources with native queries

Second best: Hide the dynamic data sources from the Formula Firewall by inlining the queries into the same Power Query partition

Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Learn

[cingram11]

Thanks! What is considered a dynamic data source, and I'm unsure of where to find the cause.

[lbendlin · Accepted solution]

Here's an example

Power Query - Dynamic Data Source and Web.Contents() - Hat Full of Data