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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors