Power BI

Completed

Allow mixing direct query and imported tables in a single model

Vote (300)

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)

Comments (31)

Tony Lau on 05 Jul 2020 23:32:53

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

This is an absolutely must have feature and provide a truly agile and flexibility to the users to work in a mix mode ie. direct query and import data to work with. This is a draw back from my point of view.

Jayden Sanders on 05 Jul 2020 23:29:07

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

This is very important for us at an enterprise level. Our use of PowerBI would increase if we could use direct query and import into a single model.

Ganesh kumar on 05 Jul 2020 23:27:57

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

Please add this feature. It will be very helpful for Power users at organizational level.

Power BI User on 05 Jul 2020 23:24:09

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

It's coming soon I think:

https://redmondmag.com/blogs/the-schwartz-report/2017/11/power-bi-soon-will-query-datasets-with-1-trillion-rows.aspx?m=1

If it in Analytic Analysis it's one step a way to be in power bi

We need it to. Because we want to connect with 5 trillion rows (over databricks)) inatalake simultaneously with import data as well