Insert Pivot table

[Rob Fletcher]

Hello Everyone, my colleague and i are big users of the Excel Power-suite of tools. We have built data models, employed Dax, created complex queries etc. and making great headway. However, when we used to click insert Pivot Table the dialogue box would allow us to go straight to the Data Model. This has vanished and regardless of how complex our workbooks, we only get the standard box.

We have checked our options and have the 'Prefer the Excel Data Model when creating Pivot Tables, Query Tables and Data Connections option checked.

All we can find is right clicking on the query we want to use and use the 'load to... option. Anyone got an idea of how we can get the preferred 'use data model' options back?

Many thanks in advance for any help you can give us.
Rob

 

[Alex Blakenburg]

I am assuming that this is not what you are after.
(I am on MS 365)

 

[Rob Fletcher]

Hi Alex, apologies, it never occurred to us to look there, we just expected the pop-up to default as it has in the past. Thank you for taking the time to answer, this will do for us.

Rob

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.
I seem to recollect someone posting that the default had changed and that they were asking for it to be changed back but I can't find the reference back so I can't be sure.

 

[Alex Blakenburg]

Found it on the MS Feedback portal (UserVoice replacement), I was pretty sure I saw it initially as a Wyn Hopkins LinkedIn comment.
MS Feedback - Keep the default "Use this Workbook's data model" option when inserting a Pivot Table