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.
Friday, October 5, 2012
Subscribe to:
Posts (Atom)
Featured Post
Closing out on 2024
It's the holiday season again, already! This year has been marked by significant advancements in Microsoft Fabric, and Power BI in speci...
-
Just before the holidays start, I'd like to share this little trick I came across in Power Query. I recently had the need to remove zero...
-
After Installing the PowerShell Power BI Management cmdlets a few months back, I finally managed to get a dataset refresh working, initiat...
-
I recently made the switch to Pulse (you can read about it here ), so I am working with lots of new clients lately. One of those clients wa...