Forum Discussion
Direct Query and Import connection in Power BI Report Server
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?
You can use Direct Query if your data source is listed as supporting it in the following article Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn the 3 column indicates if a give type of data source supports Live or Direct Query models
1 Reply
You can use Direct Query if your data source is listed as supporting it in the following article Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn the 3 column indicates if a give type of data source supports Live or Direct Query models