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.