Forum Discussion

mihofmann's avatar
mihofmann
New Member
2 years ago

Cannot use composite model

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...
Need Help
zenisekd's avatar
zenisekd
Super User
2 years ago

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's avatar
mihofmann
New Member
2 years ago

I don't think so. Here are some example steps:

1. Create DQ model:

 

2. Add Excel import:

 

3. This message pops up:

 

  • zenisekd's avatar
    zenisekd
    Super User
    2 years ago

    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's avatar
      mihofmann
      New Member
      2 years ago

      When I open this settings page it is blank. DirectQuery itself works though.

       

      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. Was hoping to at least have them available in Desktop, though.

      • zenisekd's avatar
        zenisekd
        Super User
        2 years ago

        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.