Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I'm struggling with my file.
I've built a data model from PowerQuery to PowerPivot and then created a Pivot Table, but when I delete the data from the source data it still appears on my pivot table.
As you can see below from PQ engine there is no data in my table but in my pivot table I still continue to see CapAll data
I've also done some research on google and find that pvt caches are the issue and to fix it I should change in Pvt options ==> then Data ==> Change retain items from deleted data source from Automatic to None, but in my case, this field is grayed.
Thanks in advanced for your help.
Solved! Go to Solution.
Hello - this article explains why your option is greyed out.
This article suggests checking the setting in File - Options - Data. If the "Prefer the Excel Data Model when creating PivotTables, QueryTables and Data Connections.
This article provides the steps for removing the old items manually and automatically.
Hello - this article explains why your option is greyed out.
This article suggests checking the setting in File - Options - Data. If the "Prefer the Excel Data Model when creating PivotTables, QueryTables and Data Connections.
This article provides the steps for removing the old items manually and automatically.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.