Direct Query and Import connection in Power BI Report Server

[opejoseph]

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?

[d_gosbell · Accepted solution]

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