Forum Discussion

cflater's avatar
cflater
Frequent Visitor
6 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 wo...
Need Help
  • cflater's avatar
    cflater
    6 months ago

    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. 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 months ago

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

  • cflater's avatar
    cflater
    Frequent Visitor
    6 months ago

    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
      Icon for Super User rankSuper User
      6 months ago

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

      • cflater's avatar
        cflater
        Frequent Visitor
        6 months ago

        There really is none at all. Looking at the refreshed semantic model in Service doesn't even have the full dataset in there.. wondering if it is a Sharepoint view issue