Forum Discussion

cflater's avatar
cflater
Frequent Visitor
4 months ago
Solved

Power BI Refresh Overwrites Correct Data With Old Version

I’m running into a strange Power BI Service behavior that I can’t explain.

  • I have a report that pulls data from a SharePoint Online Excel file.

  • When I publish a fresh copy of the PBIX to any workspace (including My Workspace), the data is correct.

  • As long as I don’t refresh the dataset in the Service, the report continues to show the correct data.

  • The moment I trigger a manual refresh or a scheduled/automatic refresh runs, the dataset instantly reverts to old/bad data.

  • The refresh completes in just a few seconds, which is unusually fast for a SharePoint source.

  • After the refresh, the report “flashes” the correct data for a moment, then snaps back to the old data.

  • This happens even if I:

    • delete the dataset

    • republish the PBIX under a new name

    • create a brand‑new copy of the PBIX

    • publish to a different workspace

    • reconnect the SharePoint source

    • verify the file ID is correct

  • The same behavior occurs in My Workspace, which rules out lineage, pipelines, shared datasets, or workspace‑level overrides.

  • I am connecting to the data source via Personal Cloud Connect (OAuth & Organizational)
  • There are no bookmarks or filters

I’m trying to understand why Power BI Service is reverting to outdated data after refresh, even though Desktop and the published dataset initially show the correct values.

  • Turns out it was in fact due to a Sharepoint Default View.

    PBI Desktop read the raw list data, however PBI Service read the data constrained by the Sharepoint List's Default View. To fix this, I made a view with all rows included and made that the new Default. 

5 Replies

  • Power BI Service runs on UTC.  Check your date/time filters.

    • cflater's avatar
      cflater
      Frequent Visitor

      Two years of historical data is getting removed though. It is only taking records from current month (April 2026) up until 2028

      • lbendlin's avatar
        lbendlin
        Super User

        Open the selection pane and hunt for hidden/forgotten slicers, especially synched slicers.