Because is not possible use Direct Query and Import in the same time?

[nanojau]

Hi everyone, 

I would like to understand beacause is not possible use Direct Query and Import in the same time on Power BI?

Thanks,

[dm-p · Accepted solution]

Hi @nanojau,

Power BI used to be a 'one or the other' approach with DirectQuery vs. Import, but this has changed recently. In a lot of cases it is possible to create composite models that can mix these data sources. Here's the MS documentation on it. The doc also contains an example.

There are some exceptions where you can't use composite models, though. If you're connecting to any of the following sources, they can be DirectQuery only (detailed in the Limitations and considerations section):

• SAP HANA
• SAP Business Warehouse
• SQL Server Analysis Services
• Power BI datasets
• Azure Analysis Services

Here's some further reading/viewing into composite models that may help:

• RADACAD - Composite Model; DirectQuery and Import Data Combined; Evolution Begins in Power BI 
• PowerBIPro - How to Create a Power BI Composite Model and What’s New! 

I hope this helps you out.

Daniel

---

If my post helps, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂