Skip to main content

Power BI

Completed

Allow mixing direct query and imported tables in a single model

Vote (300) Share
Srinivasan Turuvekere's profile image

Srinivasan Turuvekere on 22 Oct 2015 21:26:20

Allow direct query tables and imported tables to coexist in a single model with ability to create relationships between them.

Administrator on 17 Nov 2018 02:47:52

Our composite models feature, which lets you combine import and direct query sources in one model, is now generally available with our November release. Read more about it here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#compositeModels

Comments (31)
Srinivasan Turuvekere's profile image Profile Picture

Power BI User on 05 Jul 2020 23:13:21

RE: Allow mixing direct query and imported tables in a single model

This is really essential for making power BI more powerful

Srinivasan Turuvekere's profile image Profile Picture

Chris Kabat on 05 Jul 2020 23:10:41

RE: Allow mixing direct query and imported tables in a single model

This would be huge for power users.

Srinivasan Turuvekere's profile image Profile Picture

Power BI User on 05 Jul 2020 23:10:16

RE: Allow mixing direct query and imported tables in a single model

would be nice if this can be at object level in the dashboard pages.

Srinivasan Turuvekere's profile image Profile Picture

Power BI User on 05 Jul 2020 23:07:42

RE: Allow mixing direct query and imported tables in a single model

It is a crucial issue that can solve many database level integration workarounds.

Srinivasan Turuvekere's profile image Profile Picture

Axel Prunier on 05 Jul 2020 23:07:08

RE: Allow mixing direct query and imported tables in a single model

We definitely need this one...

Srinivasan Turuvekere's profile image Profile Picture

Henri Aalto on 05 Jul 2020 23:05:51

RE: Allow mixing direct query and imported tables in a single model

It is almost funny in how many cases my end users wish to see the finest grain details for a specific customers when they start looking deeper into some phenomenon. Any way I can easily enable them to dig deeper in to the details without exploding the model is welcome. The ability to switch to another page in the report retaining filtering values is great, now to get further the detail-page would need to fetch the most detailed data over a direct query.

Srinivasan Turuvekere's profile image Profile Picture

Marek on 05 Jul 2020 22:59:41

RE: Allow mixing direct query and imported tables in a single model

Definitelly, something we need. Also, mixing multiple sources in the direct query (for example, 2 different sql servers)

Srinivasan Turuvekere's profile image Profile Picture

Stuart Mackereth on 05 Jul 2020 22:58:25

RE: Allow mixing direct query and imported tables in a single model

We have 1500 power bi licensed users... it's really a problem explaining that the self service reporting tool doesn't allow mashups of custom data with formal data!

Biggest feature request from our organisation!

Srinivasan Turuvekere's profile image Profile Picture

Ananda Kumar on 05 Jul 2020 22:54:41

RE: Allow mixing direct query and imported tables in a single model

This is a common scenario in many of my projects. If it is self service BI then customer need to import their own Excel sheets to a direct query connection model. This is a very severe limitation.

Srinivasan Turuvekere's profile image Profile Picture

Andrew on 05 Jul 2020 22:45:41

RE: Allow mixing direct query and imported tables in a single model

This is the entire reason my company needs Power BI! I started using BI and now that I have access to our SQL Server, I came to find out I cannot combine the data I need to combine unless it becomes possible to use DirectQuery from 2 different databases on the Server plus mix in some imports.......