Forum Discussion

datagrrl's avatar
datagrrl
Advocate I
5 months ago
Solved

Dynamic Data Source, how do I identify which query is the issue?

I am getting this error when attempting to update the gateways for my semantic model.

 

You can't schedule refresh for this semantic model because the following data sources currently don't support refresh:

  • Data source for Query1

There is no Query1. I have named all of my queries.

 

I do have a graph db connection (graph.microsoft)  that gets the AD data for a set of users. The other sources in my file are all sources I have used before and have no issue with. This is the first time I have tried to upload a pbix file to the service that has a graph db connection, but I planning on using this process in the future, as it is useful for RLS.

 

I have read a few pages about the dynamic data sources, but without fully understanding where the error is, I am not sure how to fix it.

 

So first, where do I find Query1?

 

Need Help
  • Olufemi7's avatar
    Olufemi7
    5 months ago

    Hello datagrrl, 

     

    Query1” is not a real query. Power BI Service uses that name as a placeholder when it detects a dynamic or unsupported data source.

    How to identify the actual query causing the error:

    1. Open Power Query Editor.

    2. Look for queries that:

      • Build the source URL or server dynamically using variables, parameters, or functions.

      • Use Web.Contents(), OData.Feed(), or other connectors with dynamic inputs.

      • Require OAuth authentication (e.g., graph.microsoft.com).

    3. Disable load for queries one by one and republish; the query that triggers the error is the culprit.

    In your case, the Graph API query is almost certainly the issue. Power BI Service cannot schedule refresh for queries with dynamic URLs or OAuth tokens unless the source is made static or parameters are used and authentication is configured properly.

    Fix:

    • Use Power BI parameters to make the source static for refresh.

    • Ensure OAuth authentication is correctly configured.

    Reference: Troubleshooting unsupported data source for refresh

3 Replies

  • Olufemi7's avatar
    Olufemi7
    Super User
    5 months ago

    Hello datagrrl, 

     

    Query1” is not a real query. Power BI Service uses that name as a placeholder when it detects a dynamic or unsupported data source.

    How to identify the actual query causing the error:

    1. Open Power Query Editor.

    2. Look for queries that:

      • Build the source URL or server dynamically using variables, parameters, or functions.

      • Use Web.Contents(), OData.Feed(), or other connectors with dynamic inputs.

      • Require OAuth authentication (e.g., graph.microsoft.com).

    3. Disable load for queries one by one and republish; the query that triggers the error is the culprit.

    In your case, the Graph API query is almost certainly the issue. Power BI Service cannot schedule refresh for queries with dynamic URLs or OAuth tokens unless the source is made static or parameters are used and authentication is configured properly.

    Fix:

    • Use Power BI parameters to make the source static for refresh.

    • Ensure OAuth authentication is correctly configured.

    Reference: Troubleshooting unsupported data source for refresh

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    5 months ago

    Hi datagrrl 

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.


    Thank you.

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    5 months ago

    Hi datagrrl 

    May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.


    Thank you