cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
biz_wiz Frequent Visitor
Frequent Visitor

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)

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
adrez86 Regular Visitor
Regular Visitor

Re: DirectQuery and the SQL Server requirement of Report Server

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

1 REPLY 1
Highlighted
adrez86 Regular Visitor
Regular Visitor

Re: DirectQuery and the SQL Server requirement of Report Server

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