topic Re: Unable to connect to SQL Server in Report Server

Unable to connect to SQL Server

Anonymous — Mon, 05 Apr 2021 11:22:01 GMT

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)'"

Re: Unable to connect to SQL Server

KBO — Mon, 05 Apr 2021 16:05:49 GMT

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!