Forum Discussion
Dataset Not Loading After Power Query Edits – Stuck on Syncing Schema
Power BI Desktop gets stuck on "Syncing Schema" after Power Query changes because the semantic model cannot reconcile the updated structure (new columns, data types, or Advanced Editor modifications) with the existing model.
Primary Solution
Close Power BI Desktop completely, ensuring no PBIDesktop.exe processes run in Task Manager (use End Task if needed), then reopen the PBIX file; this forces a clean schema sync on reload. After reopening, go to Transform Data > Refresh Preview at the Navigation step for each query, cancel any hanging refreshes, then select Refresh All until previews load, and finally Close & Apply.
Additional Fixes
Expand the Refresh button (Home or Data pane) and select "Sync schema only" first to update the model structure without full data reload, then refresh data separately if needed.
Clear data source credentials via Transform Data > Data source settings > Clear permissions, re-enter them, and check for large datasets or slow sources causing hangs.
If persistent, save as a new PBIX, disable auto-recovery, or update to the latest Power BI Desktop version to address known refresh bugs.
Hello amitchandak
Thank you for your response and guidance. I followed the steps you suggested, but when I refresh Meta first, the evaluation pop-up window does not close as shown in the screenshot.
If I click Cancel, it displays an error message for each dataset, as shown below.
Not able to find the exact root cause and its very difficult to rebuild the report from scratch.
Request everyone to suggest any other solution to fix this issue.
Thank you for your support.
Regards,
Manohar