can i combine direct query and import in a power bi application

[ptepichin]

Good afternoon, 

Is it possible to use a hybrid Data Connectivity Mode utilizing both Import and Direct Query connections in a Power BI visualization?

[sam_gift]

Hi, Currently there is a limitation in refreshing the composite model semantic model. Please assist how to overcome it.

[v-yadongf-msft · Accepted solution]

Hi @ptepichin ,

When you use DirectQuery, composite models make it possible to create a Power BI model, such as a single .pbix Power BI Desktop file, that does either or both of the following actions:

• Combines data from one or more DirectQuery sources.
• Combines data from DirectQuery sources and import data.

For example, by using composite models, you can build a model that combines the following types of data:

• Sales data from an enterprise data warehouse.
• Sales-target data from a departmental SQL Server database.
• Data that's imported from a spreadsheet.

A model that combines data from more than one DirectQuery source or that combines DirectQuery with import data is called a composite model.

For more information, please refer to: Use composite models in Power BI Desktop - Power BI | Microsoft Learn

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@ptepichin Yes. You can even have a single table with both DirectQuery and Import partitions or a combination of tables in DirectQuery only mode, import only mode and even Dual mode (both DirectQuery and import). Dual mode is different than having multiple partitions, one DirectQuery and one import.