Forum Discussion

Jmrc16's avatar
Jmrc16
Frequent Visitor
8 months ago
Solved

Error during refresh

Hello everyone!!   I have a power BI report that works perfectly, however, a day ago there was a few changes in a dataset table, a user deleted some rows. I strarted receiving alerts with timeout ...
Need Help
cengizhanarslan's avatar
cengizhanarslan
Super User
8 months ago

Hi,

Instead of clicking directly to the "Refresh" button, try "Schema and data" under the Refresh. This will first update the schema then the data.

 

 

  • Jmrc16's avatar
    Jmrc16
    Frequent Visitor
    8 months ago

    That is what I tried, but it doesn't work and it stills loading .

     

    • cengizhanarslan's avatar
      cengizhanarslan
      Super User
      7 months ago

      Since you are using an API connector (Airtable), there is no Query Folding. You must filter at the source. Could you check the size of the tables? If they are massive, you should create a View in Airtable that contains only the fields required for your report. This dramatically reduces the amount of data Power BI has to download and process, which should resolve the timeout.

      Also, complex relationships can also cause refresh failures and performance issues, especially with large tables:

      • Are you using a Star Schema? This is vital for performance.

      • Do you have any Many-to-Many or Bi-directional (two-way) relationships? These should be minimized as they put a heavy burden on the VertiPaq engine during both refresh and report interaction.