Connect to a Data Model !
It would be massively useful to be able to connect to a Data Model in a workbook from a separate one
So if you were using Power Query one of your data sources could be a data model in a workbook
This would expose all the tables within the Data Model and let you connect to one as your source
this feature is a must. PowerBI already has this
Yes please! Really need this.
can't believe there's only 8 votes for this....
Chris Bates commented
Totally agree. Its a constant frustration that I have to split my data into mutiple files due to size and can't interrogate all the data models from Excel or Power BI.