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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
edcarden
Helper I
Helper I

Sharing Connections - How To Share Data Connections in Power BI

In Power BI Desktop is there a way to share a SQL Server database connection or any other type of cponnection that Power BI Desktop supports?

 

I am able to connect to a SQL Server instance thats in our vendors cloud but a co-worker who is on teh same netwrok as I is unable to do the same.  We are connecting to a SQL Server 2008R2 DB using a SQL Srever Login/DB User and password (not Windows Authentication).  For whatever reason I am able to sucesfully connect with the same SQL L9ogin+PWD that my co-worker can not.  We're both on the latest verison of Power BI.  He is on Windows 10 and I an on Windows 7 so Im not sure if thats relevant.  I was thinking that if there was someo way for me to share with him teh connection that I can get to work then maybe that woudl get aroundd whatever uis preventing him from connecting. 

 

Thoughts

1 REPLY 1
Greg_Deckler
Super User
Super User

Unless I am mistaken about what you are trying to accomplish, I believe the answer is to use the Enterprise Data Gateway. You can setup connections there that everyone can use (if you give them access).


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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