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
My DataGrillen Adventure: Speaking, Connecting, and New Friendships
I just got back from an incredible trip to DataGrillen, and I can’t wait to share my experiences with you. If you haven’t heard of it, Data...
-
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...
-
Problem Recently I was working on a new project and was trying to deploy my SSIS project with several packages to the catalog for the first ...
No comments:
Post a Comment
Thanks for taking the time to provide feedback!
Cheers,
Nicky