Forum Discussion

Isajp2002's avatar
Isajp2002
New Member
8 months ago
Solved

Error in scheduled refresh

Hello! I have a Power BI report connected to a SharePoint Online list. This SharePoint list receives data from a Power App, and that part works fine. However, when new data is added to the SharePoi...
Important
powerbi
refresh error
  • Zanqueta's avatar
    Zanqueta
    8 months ago

    Hi Isajp2002 

     

    You must open your file in power bi desktop and check your query Data source for Query1 and resolve the error on the dataset and then re-enable.

     

     

    How to fix it

    1. Check the error details:
      • Navigate to Dataset Settings → Refresh History.
      • Review the last error message (for example, authentication issue, missing credentials, query timeout).
    2. Resolve the root cause:
      • If it is a gateway issue, ensure the gateway is online and correctly mapped.
      • If it is credentials-related, re-enter them under Data Source Credentials.
      • If it is a query error, validate your transformations in Power Query.
    3. Re-enable scheduled refresh:
      • After resolving the error, go to Dataset Settings → Scheduled Refresh.
      • Switch Keep your data up to date back to On.

    Common causes

    • Expired credentials (OAuth tokens, database passwords).
    • Gateway offline or not updated.
    • Query changes that break folding or cause timeouts.

     

    Official reference:

    Troubleshoot refresh scenarios - Power BI | Microsoft Learn

     

    If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

    Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.

Zanqueta's avatar
Zanqueta
Super User
8 months ago

Hi Isajp2002,

Before continuing to invest time in Power Automate, it is worth assessing whether this solution is truly necessary. For data stored in the cloud, such as SharePoint Online, Power BI already supports scheduled refreshes directly in the service without requiring an additional flow.
 

Why Consider Scheduled Refresh?

  • Power BI Service can synchronise datasets with online sources without a gateway.
  • You can set a reasonable frequency, for example every hour, which is sufficient for most scenarios.
  • This approach is simpler, more stable, and does not depend on additional integrations.

 

Only if you require immediate refresh after each item is added via Power Apps.
 
 

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.

  • Isajp2002's avatar
    Isajp2002
    New Member
    8 months ago

    Hi Zanqueta 

    Thank you very much for your answer! and yes i did that but somehow the refresh button doesn't appear any more instead this message is shown: 

    and here where there should be the button it's not : 

    Do you know what can I do? Or how should I fix it?

    • Zanqueta's avatar
      Zanqueta
      Super User
      8 months ago

      Hi Isajp2002 

       

      You must open your file in power bi desktop and check your query Data source for Query1 and resolve the error on the dataset and then re-enable.

       

       

      How to fix it

      1. Check the error details:
        • Navigate to Dataset Settings → Refresh History.
        • Review the last error message (for example, authentication issue, missing credentials, query timeout).
      2. Resolve the root cause:
        • If it is a gateway issue, ensure the gateway is online and correctly mapped.
        • If it is credentials-related, re-enter them under Data Source Credentials.
        • If it is a query error, validate your transformations in Power Query.
      3. Re-enable scheduled refresh:
        • After resolving the error, go to Dataset Settings → Scheduled Refresh.
        • Switch Keep your data up to date back to On.

      Common causes

      • Expired credentials (OAuth tokens, database passwords).
      • Gateway offline or not updated.
      • Query changes that break folding or cause timeouts.

       

      Official reference:

      Troubleshoot refresh scenarios - Power BI | Microsoft Learn

       

      If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

      Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.