Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

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

13 votes
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

Anthony Newell shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Chris Bates commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base