Composite model: how to add DQ in future?

[AnetaK]

Hello,

I am creating a report where I use aggregated data in Import mode.

In future I am going to enrich the report with some more datailed data and I should be able to connect to another source with DQ.
As I see, I can create a composite model only when DQ is a first source.

What can I do to be able to add DQ later?

[v-juanli-msft]

Hi @AnetaK 

As tested, i can import a table from SQL Server, then connect to a table from SQL Server in direct query mode,

After that, i can change the storage to dual.

Do you connect to multi-dimensional sources by using DirectQuery?

If so, you can't connect to another DirectQuery source or combine it with Import data.

Limitation here:

https://docs.microsoft.com/en-us/power-bi/desktop-composite-models#limitations-and-considerations

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.