Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors