Forum Discussion
DirectQuery and the SQL Server requirement of Report Server
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)
SQL Server is used to host the report server database so yes SQL server will still be needed.
1 Reply
- adrez86Helper I
SQL Server is used to host the report server database so yes SQL server will still be needed.