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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
khochschild
Frequent Visitor

Power BI Embed Report - Use Direct Query with SQL Server database

Is there a way to embed a report while using a SQL Server Database that is on my server instead of the Azure SQL Database?

I can get it to work when I publish the report through Power BI Service, but can't get any datasources when I try to embed the report.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @khochschild,

 

If you use PowerBi Workspace Collections (which are retired and soon their support will be ended), there's no specific gateway and DirectQuery mode only supports Azure SQL database and Azure SQL data warehouse. If in this case, it is not applicable for you, because you're using SQL Server in DirectQuery mode.

 

If you use the new  Power BI Embedded capacity-based SKUs, the pbix files are published to the service. In this case, you can just set up gateways and use DirectQuery modes for all supported data sources.

 

Here you can find the data sources supported by DirectQuery in Power BI and which needs a gateway. 

 

Hope this helps.

 

Regards,

 

Thanos

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @khochschild,

 

If you use PowerBi Workspace Collections (which are retired and soon their support will be ended), there's no specific gateway and DirectQuery mode only supports Azure SQL database and Azure SQL data warehouse. If in this case, it is not applicable for you, because you're using SQL Server in DirectQuery mode.

 

If you use the new  Power BI Embedded capacity-based SKUs, the pbix files are published to the service. In this case, you can just set up gateways and use DirectQuery modes for all supported data sources.

 

Here you can find the data sources supported by DirectQuery in Power BI and which needs a gateway. 

 

Hope this helps.

 

Regards,

 

Thanos

PawelM25
New Member

Hello Khochschild,

 

You may have to set up a Enterprise or Personal Gateway to create a connection between your on-prem SQL server, and the Embedded report.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.