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
Zanqueta's avatar
Zanqueta
Super User
8 months ago

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's avatar
Jmrc16
Frequent Visitor
8 months ago

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.