cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Unable to connect to SQL Server

SQL Management Studio is connected to another server using admin credentials. Can I connect this database with Power BI using my personal credentials on my own device? Currently getting the following error

 

"An error happened while reading data from the provider: 'Could not load file or assembly 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Either a required impersonation level was not provided, or the provided impersonation level is invalid. (Exception from HRESULT: 0x80070542)'"
1 REPLY 1
KBO
MVP

Hi @Anonymous ,

maybe this post will help you with your problem: https://community.powerbi.com/t5/Desktop/Unable-to-Connect-to-SQL-Server/m-p/202262

 

Best,

Kathrin

 

 

 

 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.