https://community.fabric.microsoft.com/t5/Report-Server/Direct-Query-and-Import-connection-in-Power-BI-Report-Server/m-p/3280847#M30100 <P>You can use Direct Query if your data source is listed as supporting it in the following article&nbsp;<A href="https://learn.microsoft.com/en-us/power-bi/report-server/data-sources" target="_blank">Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn </A> the 3 column indicates if a give type of data source supports Live or Direct Query models</P> Tue, 13 Jun 2023 05:30:10 GMT d_gosbell 2023-06-13T05:30:10Z https://community.fabric.microsoft.com/t5/Report-Server/Direct-Query-and-Import-connection-in-Power-BI-Report-Server/m-p/3279048#M30086 <P>So i noticed it seems power bi report server only supports import mode (i have a scheduled refresh connection to my live database). I am trying to reduce the file size on the server . Is there an option to switch to direct query like we do on PBI Service?</P> Mon, 12 Jun 2023 08:29:07 GMT https://community.fabric.microsoft.com/t5/Report-Server/Direct-Query-and-Import-connection-in-Power-BI-Report-Server/m-p/3279048#M30086 opejoseph 2023-06-12T08:29:07Z https://community.fabric.microsoft.com/t5/Report-Server/Direct-Query-and-Import-connection-in-Power-BI-Report-Server/m-p/3280847#M30100 <P>You can use Direct Query if your data source is listed as supporting it in the following article&nbsp;<A href="https://learn.microsoft.com/en-us/power-bi/report-server/data-sources" target="_blank">Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn </A> the 3 column indicates if a give type of data source supports Live or Direct Query models</P> Tue, 13 Jun 2023 05:30:10 GMT https://community.fabric.microsoft.com/t5/Report-Server/Direct-Query-and-Import-connection-in-Power-BI-Report-Server/m-p/3280847#M30100 d_gosbell 2023-06-13T05:30:10Z