https://community.fabric.microsoft.com/t5/Report-Server/Direct-query-and-import/m-p/1496499#M16730 <P>Hi,</P><P>I'm making reports in the server version of PowerBI desktop.</P><P>&nbsp;</P><P>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.</P><P>It seems to make the whole report Import at that time.</P><P>&nbsp;</P><P>Is this by design in the report version?</P> Mon, 16 Nov 2020 13:30:10 GMT Anonymous 2020-11-16T13:30:10Z https://community.fabric.microsoft.com/t5/Report-Server/Direct-query-and-import/m-p/1496499#M16730 <P>Hi,</P><P>I'm making reports in the server version of PowerBI desktop.</P><P>&nbsp;</P><P>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.</P><P>It seems to make the whole report Import at that time.</P><P>&nbsp;</P><P>Is this by design in the report version?</P> Mon, 16 Nov 2020 13:30:10 GMT https://community.fabric.microsoft.com/t5/Report-Server/Direct-query-and-import/m-p/1496499#M16730 Anonymous 2020-11-16T13:30:10Z https://community.fabric.microsoft.com/t5/Report-Server/Direct-query-and-import/m-p/1497896#M16739 <BLOCKQUOTE><HR />Anonymous</LI-USER>&nbsp;wrote:<BR /> <P>Is this by design in the report version?</P> <HR /></BLOCKQUOTE> <P>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.</P> Tue, 17 Nov 2020 04:29:24 GMT https://community.fabric.microsoft.com/t5/Report-Server/Direct-query-and-import/m-p/1497896#M16739 d_gosbell 2020-11-17T04:29:24Z