PowerBI Report Not Syncing in WorkSpace after Publish

Hi jhfhiworks ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you amitchandak for the prompt response.

Here are some steps to fix the issue:

1. Make sure to Check the Gateway if used:

• Go to Power BI Service > Settings > Gateways.
• Make sure your data source is added and configured correctly in the gateway.
• Ensure it uses the same credentials and exact same query path/table that you’re using in Desktop.
• If you're using a file (Excel, CSV) or on-prem SQL, ensure the file/table being referenced is the same version as on Desktop.

2. Make sure to Clear Cached Metadata:
In Power BI Desktop, go to: 

• File > Options and Settings > Data Source Settings > Clear Permissions
• Remove and reauthenticate to the data source.
• Reopen Power Query Editor, refresh the preview, and ensure the column exists.
• Then republish to the Service again.

3.Sometimes the Service holds on to stale metadata, especially if you renamed or added columns.

You can try the below steps:

• Open your dataset in Power BI Desktop.
• Delete the problematic column (UserPreferencesOptOutOfTouch) in Power Query.
• Close & apply. Save. Publish.
• Confirm that refresh now works (with the column gone).
• Now, reopen Desktop, add the column back, and re-publish.
• This sometimes forces the Service to "reset" its internal metadata cache.

4. Try to verify the Column's Case Sensitivity & Data Types:
1.Power BI is case-insensitive in visuals, but not always during schema refreshes-especially when SQL or OData is involved. If the column in source is userpreferencesoptoutoftouch vs. UserPreferencesOptOutOfTouch, you may have a mismatch in some queries.

2.Also, make sure the column data type didn't change (e.g., text → boolean), which could cause issues with refresh.

5. Try to Check Advanced Query Transformations:
If you’ve applied transformations like:

• Removed Other Columns
• Reordered Columns
• Renamed Columns after filtering steps

And your data source changed its column order or names slightly, this can break during Service refresh but not Desktop.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.