cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
biz_wiz
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
adrez86
Helper I
Helper I

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

View solution in original post

1 REPLY 1
adrez86
Helper I
Helper I

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

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.