Refresh data

[grumant]

Hi,

I updated some cells in the Excel sheet that serves as the source for Power BI, changing them from "fritid" to "bedrift." However, when I click "Refresh" in Power BI, the pivot table doesn’t update. I’ve cleared the cache, but nothing seems to work. "Bedrift" is also selected in the filter for this view. Does anyone have tips on why this isn’t getting updated?

[rajendraongole1 · Accepted solution]

Hi @grumant - you can check this at power query Editor(Transform Data) and check if the changes made in the Excel file are visible in the query preview. If they are not, there might be an issue with how the data is being pulled from Excel.Also, check for any filters, steps, or transformations that might be preventing the updated data from being loaded into Power BI.

Important thing, check the connection to the Excel file is correctly set up. Verify that the pivot table in Power BI is using the correct fields and that no old fields or filters are interfering with the updated data only.check that the filters, datatypes in your pivot table (or any slicers) are not preventing "bedrift" from appearing.

Hope this information helps to identify your issue.