Forum Discussion
Connecting to a Power Pivot model from another Excel workbook
Hello Anonymous
the only possibility to access the data model itself it's only possible when you have opened the other Excel with the datamodel (if even - i know it's possible with Power BI). But this doesn't suit the most business scenario.
The way I've solved such issues to create in your excel as many pivots as you need in other scenarios and then access the data of the pivot table. However you have to update the excel-file manully, every time your data model changes.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
The solution has two downwards when dealing with big data: 1) nowadays databases can easily reach the ~1M rows threshold; 2) even if the limit is not reached, the workbook performance becomes extremely bad.