Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Reply
CLWendt88
New Member

Connect to SQL Server instance on Azure VM without Data Gateway

‎12-02-2020 07:06 AM

Is it possible to connect to to a SQL Server instance running on an Azure VM without the data gateway?  

 

Maybe by whitelisting the IPs of the Power BI service? 

 

Or is there a way to use Private Endpoints so Power BI Service can securely access the SQL instance?

Labels:
Message 1 of 2
1,625 Views
0
1 ACCEPTED SOLUTION
Anonymous
Not applicable

‎12-07-2020 01:11 AM

Hi @CLWendt88 ,

 

You are connecting to a SQL Server that hosted in Azure VM but not Azure SQL database in Power BI Desktop. For the former, gateway is required, you can install gateway on the same machine with Power BI Desktop, then add SQL Server data source within the gateway. Otherwise, you are not able to view the published report in Power BI Service.
For Azure SQL database, gateway is not required.

 

Best Regards,

Jay

View solution in original post

Message 2 of 2
1,569 Views
0
1 REPLY 1
Anonymous
Not applicable

‎12-07-2020 01:11 AM

Hi @CLWendt88 ,

 

You are connecting to a SQL Server that hosted in Azure VM but not Azure SQL database in Power BI Desktop. For the former, gateway is required, you can install gateway on the same machine with Power BI Desktop, then add SQL Server data source within the gateway. Otherwise, you are not able to view the published report in Power BI Service.
For Azure SQL database, gateway is not required.

 

Best Regards,

Jay

Message 2 of 2
1,570 Views
0

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All