none
Can't connect to SQL Server via Power BI Desktop RRS feed

  • Question

  • I keep getting the error below when I try to connect to Sql Server via Power BI - Desktop.

    I have tried the following

    Running Power BI as administrator - didn't work

    Reinstalling .net framework 4.7.2 and restarted my computer - didn't work

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


    I can connect to database server through sql server.

    Any help please. Thanks


    Thursday, November 8, 2018 11:06 AM

All replies

  • Hello ilylenos.

    Right click on Power BI Desktop icon and then click on Run as Administrator.

    Regards,

    Pascual Perdomo


    Pascual Perdomo / Diviserv S.A. / Paraguay / Microsoft® Certified Professiona (MCP) / Microsoft® Certified Technology Specialist (MCTS) / MCITP Enterprise Administrator on Windows Server® 2008 / MCITP Enterprise Messaging Administrator on Exchange 2010 / MCSA Windows Server 2008 (MCSA) / MCSA Windows Server 2012 (MCSA) Charter Member / MCSE Private Cloud (MCSE)

    Thursday, January 17, 2019 6:41 PM
  • I have the same issue.  

    Tried these suggestions with no luck:

    -Reinstalling .net framework 4.7.2,

    -Running Power BI as Admin,

    -Replacing the dlls, 

    -Cleaning the TEMP folder

    - Disabling the Anti Virus

    -Firewall- not relevant in my case

    Nothing helps,...


    Tuesday, March 19, 2019 2:58 PM
  • Same issue, no resolution.

    I can connect fine on my laptop on Win 10 Enterprise 1809 fully updated. A co-worker gets the above error, and has a very similar laptop. 

    We both have the same Windows/DotNet, Office version. I do have Visual Studio 2017 installed...

    Any ideas are welcome. I would install VS on his system, but that would be silly me thinks as he would never use it. I'm sure most people in business units don't. 

    Thanks!

    Mark

    Tuesday, September 24, 2019 8:46 PM