Cannot use composite model

Question

I currently have a DirectQuery model created from a SQL Server query. Now I want to add an excel file import to create a composite model. But when I add the import, a popup says if I want to continue I'll have to switch all models to import mode. I read the documentation and searched all over the internet, but can't find any solution. Desktop version is 2.121.1642.0 64-bit (September 2023).

Thanks a lot for your help!

zenisekd · Answer

Any chance that you have mistaken"adding local model" with switching to import mode?

When I connect anything to my Power BI Dataset data source, I get this message.

Adding a local model doesn't switch to import however.

mihofmann · Answer

I don't think so. Here are some example steps:1. Create DQ model:&nbsp;2. Add Excel import:&nbsp;3. This message pops up:&nbsp;

zenisekd · Answer

There must be something wrong with your settings. I tried at mine and worked fine. Any chance you have this button on?

Check your global and current file settings.

Does the DQ work fine just by itself, without adding the excel file? Can you load the data to desktop?
Any chance your privacy settings on desktop would not allow it?

mihofmann · Answer

When I open this settings page it is blank.&nbsp;DirectQuery itself works though.&nbsp;I think it might have to do with my corp limiting the features to those available in Power BI Report Server. For regulatory reasons we can only use on-premise and Report Server does not support composite models yet.&nbsp;Was hoping to at least have them available in Desktop, though.

zenisekd · Answer

Very likely.Can you publish your DQ to Service? If yes, you could try to connect to Power BI Dataset and then try adding the Excel.&nbsp;

Forum Discussion

Cannot use composite model

6 Replies

Related content

Cannot use composite model functionality (change your model)

RLS in Composite Model

Composite model sluggish, should use Direct Lake?

PowerBI Embedded with composite model

Model composite with seperate table