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)

c858d2d4 064b-4fff-a259-7a879dc483d7 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.

0787f73a f5e8-42fe-89af-c71b609da5e8 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.

25e39fd0 88b3-410a-8ba1-dfa380dfe6b7 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.

71094d34 bd2b-4edb-80c6-3f7aede5ce92 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