Rob Fletcher
New Member
- Joined
- Jan 8, 2010
- Messages
- 20
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
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