Data in Desktop not Matching Workspace

Hi all,

I’m running into an issue where the same Power BI report returns different results depending on where it is published and refreshed.

In Power BI Desktop, the total count is correct. When I publish the report to My Workspace, it remains consistent and still shows the correct total even after a manual refresh.

However, when I publish the exact same report to another workspace that is on Fabric capacity, the behaviour changes. Right after publishing, the total looks correct, but once I run a manual refresh in the service, the number drops significantly.

After checking further, it looks like certain records are no longer being classified correctly after the refresh in that workspace. The field driving the count is a text column coming from an appended table, so it does not appear to be a simple data type issue.

What stands out is:

• Desktop shows the correct result
• My Workspace also shows the correct result after refresh
• The Fabric capacity workspace shows a different result only after refresh

There are no report level filters or visual settings causing this. If I download the report from the service and refresh it locally, the correct result comes back again.

At this stage, it seems like the dataset is being processed differently during refresh in the Fabric workspace compared to Desktop and My Workspace.

Has anyone seen this kind of behaviour before, especially with appended tables or text fields returning different results after a service refresh?

Any help would be appreciated.