Forum Discussion

fcoy's avatar
fcoy
Regular Visitor
4 years ago

Data in Desktop not Matching Workspace

I built a report in Power BI Desktop that is connected to a SPO list. The total number I get in the matrix table matched the number in the workspace until I deleted some entries in SP. Now, the BI Desktop reflects the correct number but the workspace still shows the old number prior to my deletions of items in the list. 

 

Occasionally, When I refresh the desktop, publish, and refresh the data source in the workspace the numbers will match but soon, upon reloading the report, the numbers won’t match again. It’s behaving as if the workspace is using cached data somehow verses using what’s been published to it.

 

Can anyone help me resolve this?

Need Help

6 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Sharepoint data sources are refreshed in the workspace "roughly every hour" according to the official documentation.  If you need it faster you can add your own refresh requests.

    • fcoy's avatar
      fcoy
      Regular Visitor
      4 years ago

      Thank you, Ibendlin, for the response. The refresh schedule is not the issue. The issue is the numbers I get in the reports in Power BI Desktop don't match the numbers the are shown in the workspace? Any idea why that is happening?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi fcoy ,

     

    According to your description, you have firstly refreshed data in Desktop ,then re-published the report to service , and the data will be updated, right?

     

    If so, please try to refresh dataset manually in service, make sure it has successfully refreshed.

    And then open the report ,click "F5" to refresh the report again to avoid the delay.

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • deanidumwonyi's avatar
    deanidumwonyi
    Regular Visitor
    4 months ago

    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.