Error during refresh

[Jmrc16]

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 error in power bi service and when I tried to refresh the report in power bi desktop, it doesn't refressh, only loads the data from tables but doesn't syncronize the schema.
How can I fix this error?? I'm using import mode and there are big tables, but the report worked perfectlly!!

[v-ssriganesh]

Hello @Jmrc16,

Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.

Thank you.

[cengizhanarslan]

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.

[v-ssriganesh]

Hi @Jmrc16,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @Irwan, @ChielFaber, @Zanqueta & @cengizhanarslan  for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

[ChielFaber]

What's the data source? Can you try connecting a new PowerBI file to a single (or all) table from the source to check if this loads without any problems.

[Jmrc16]

I'm pulling data from Airtable using the API.

I have already deleted the measures table and the tables with data was loaded. However, when I build the measures table again, the refresh doesn't load.

[Irwan]

hello @Jmrc16 

if your user only deleted the row, it should not affect the table structure. unless your user change column such as removing column or renaming header name.

refreshing in power query only for preview and it only show partial of your data. if the error is outside the preview, then it will show no error until the whole data was imported to power bi.

as many experts here mentioned, you need to share what error do you get.

if there is an error in power bi service, power bi will send an error notification either to email or in workspace.

Thank you.

[Jmrc16]

This is the message that I received when the refresh failled and when I try to refresh manually.

[Irwan]

hello @Jmrc16 

try reading these posts, maybe there is a solution matched to your case.

Solved: Connection Timeout Issue - Microsoft Fabric Community

Solved: The XML for Analysis request timed out before it w... - Microsoft Fabric Community

Solved: The XML for Analysis request timed out before it w... - Microsoft Fabric Community

Thank you.

[ChielFaber]

Could you share the error-message that you recieve when you refresh the report?

[Jmrc16]

When I refresh in power querry, the tables are loaded, but when I try to do it in view mode, it stills loading eternally.
If I try to refresh in power bi service, it returns a timeout error.

[Zanqueta]

Hi @Jmrc16 

The error indicates that Power BI cannot synchronise the schema of the model with the data source after changes were made to the table. Since you are using Import Mode, the model expects the table structure to remain exactly as it was when the report was created.

How to Resolve It

1. Check for Schema Changes

• Open the data source (SQL, Excel, etc.) and confirm that all columns used in the model still exist.
• If any column was removed or renamed, you will need to adjust the queries in Power Query.

---

2. Update Queries in Power Query

• In Power BI Desktop, go to Transform Data.
• Check for errors in the steps (red icons).
• If columns are missing, remove or replace those references.
• Then Close & Apply.

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 🌀.

[Jmrc16]

All the tables still having the same structure, only some rows was deleted.
When I refresh in power querry, the tables are loaded, but when I try to do it in view mode, it stills loading eternally.
If I try to refresh in power bi service, it returns a timeout error.

[cengizhanarslan]

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]

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

[cengizhanarslan]

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.