DirectQuery and the SQL Server requirement of Report Server

[Anonymous]

Hi,

I'm relatively new to Power BI and would like to clarify something.

I understand from the Hardware and Software requirements and the installation guide that a SQL Server is required to install/ configure Power BI Report Server. I also understand, than when DirectQuery is used as opposed to Import, the underlying data source (in my case, on-premises Oracle DB) is queried when reports and visuals are rendered. The data would not reside in the SQL Server.

My question is: would I still need a SQL Server if I only used DirectQuery for a direct connection to my Oracle DB? (no Import)

[adrez86 · Accepted solution]

SQL Server is used to host the report server database so yes SQL server will still be needed.