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
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
Thanks for the reply, Jimmy...was afraid this would be the case ;). Anyhow, it is what it is...
Regards,
Balazs
Hello Anonymous
i don't know if you got me right. The solution i've implemented is working well.
Just use PowerQuery of Excel to get the data of the central excel-file and you can automate everything.
So just create pivot-tables that contain every data you need and thats it
What do you think about it?
Jimmy
Yes , I understood you, Jimmy.
The one problem we face is that the complete data model, once all data is displayed, is huge.
It is a pity we cannot use instead of "Thisworkbookdatamodel" something like "THATworkbookdatamodel"...i.e. to reference or connect to another workbook...Thanks again!
Balazs
I'd like to be able to do this too, or, even just connect to the main"output" table in the data model from another workbook. It seems the only way to do it is presently is to return the datamodel table/s to worksheets - which can be done provided no table has more than 1m lines (you could conceivably split a larger table over several/many worksheets, you could automate that with power query, but it's already a kludge and this would make it even slower I guess). There seems to be no good answer at the moment other than sql server and/or other more "industrial" solutions.
