Something strange happened this week when I was giving a PowerPivot training.
The PowerPivot Field list disappeared and the PivotTable Field List came back. This happened after a few minutes after I had made a PowerPivot table in a new document. It seemed to happen just in a moment, not after any particular action. Saving, closing and reopening the document solved the problem.
This triggered me to look at the autosave options. When you create a new document and autosave is on, make sure it saves it with the right extension. In this case, the format of autosave was on OpenDocument Spreadsheet (.ods). This caused the PowerPivot Field list to disappear and only the PivotTable field list was available.
This can be undone when the document type of autosave is on Excel Workbook.
The autosave options can be changed under File > Options > Save.
Blogging about Microsoft Fabric, Power BI, Power Platform and other things I find interesting.
Subscribe to:
Post Comments (Atom)
Featured Post
Quick Tip: Get Ready for Changes in OneLake Operation Reporting
Check Your Capacity Metrics App Just a quick heads-up for anyone using the Fabric Capacity Metrics app to monitor OneLake usage. One of the...
-
Another post on my favorite topic: Governance and Administration! With all the Fabric announcements in the last months, some of the Admin an...
-
It's been a while since I've written on a regular cadance, so I'm picking up my favorite topic again: Governance and Administrat...
-
I'm picking up my favorite topic again: Governance and Administration! With all the Fabric announcements in the last months, some of the...

No comments:
Post a Comment
Thanks for taking the time to provide feedback!
Cheers,
Nicky