Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Direct query and import

Hi,

I'm making reports in the server version of PowerBI desktop.

 

when i want to make sure i'm using Direct Query it seems that, if i'm using a new tabel, (For example a measure table) the server version dont give me the option to choose for direct query or import.

It seems to make the whole report Import at that time.

 

Is this by design in the report version?


  • Anonymous wrote:

    Is this by design in the report version?


    Yes this is by design. The on-prem Power BI Report Server does not currently support composite models, so your entire model has to be in either direct query mode or in import mode. You cannot choose the mode per table.

1 Reply


  • Anonymous wrote:

    Is this by design in the report version?


    Yes this is by design. The on-prem Power BI Report Server does not currently support composite models, so your entire model has to be in either direct query mode or in import mode. You cannot choose the mode per table.