-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Where is the data model located?
- Thread starter INN
- Start date
MCLIFTO8
Board Regular
- Joined
- Nov 13, 2022
- Messages
- 92
- Office Version
- 365
- Platform
- Windows
PQ queries and the data model are located separately and are separate entities.
PQ is located inside the data tab in the "Get data" array of buttons.
When using PQ the checkbox "Add this data to the data model" adds the tables to the relational data model. This is an alternative to simply merging two or more queries and creating another table. For this reason, it's more memory efficient to make relational data models and is considered best practice. However the option to simply create the connection and/or view that query in a table separates it from the Data Model.
To access the Data Model go to the power pivot tab and click the green "Manage" button
PQ is located inside the data tab in the "Get data" array of buttons.
When using PQ the checkbox "Add this data to the data model" adds the tables to the relational data model. This is an alternative to simply merging two or more queries and creating another table. For this reason, it's more memory efficient to make relational data models and is considered best practice. However the option to simply create the connection and/or view that query in a table separates it from the Data Model.
To access the Data Model go to the power pivot tab and click the green "Manage" button
Upvote
0
