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
s-turn
Resolver I
Resolver I

Anyone connecting PowerBI to a remote instance of SQL Server?

Hello,

 

I currently connect PowerBI to a load of .csvs exported from the front end of our CRM system, as we do not have access to the back end, which is hosted by the supplier.  I'd really prefer to connect to the data via SQL Server.  Our CRM supplier has offered to give us access via a VPN - the SQL Server database and SSMS will still be hosted on their server.  Does anyone have a set-up like this?  Is it straightforward to connect to PowerBI?  Any pitfalls I should be aware of?  Apologies if this is a silly or basic question - I'm not a database admin or IT specialist (though I am experienced in querying SQL), and we don't have one of those!

 

Thank you.

1 REPLY 1
lbendlin
Super User
Super User

As long as both your Power BI Desktop and your Power BI Gateway cluster members can see the SQL server through the VPN this will work fine.

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.