Forum Discussion

SiWill2017's avatar
SiWill2017
Frequent Visitor
9 years ago
Solved

Unable to Connect to SQL Server

 I keep getting the following error message when trying to connect to the companies SQL Server, does anyone have any idea of how to solve this?

 

"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 have tried to install a newer version of .net framework but I have one that is 4.5 or newer.

 

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

 

Thanks.

  • thaslett's avatar
    thaslett
    8 years ago

    Hello,

    I just wanted to add my experience to this. As the Network Manager, I was not comfortable allowing a user to run with admin credentials, so I wanted to find a way around this issue.

     

    I also did have to use Run As Admin to get the connection to work. I discovered that I only needed to do that to establish the connection, though. Once I did, the program could then be run without the Run As Admin option and it would work.

     

    Hope that helps someone.

18 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    SiWill2017

     

    As the error message mentioned, it seems a permission issue when loading the assembly, please try to run Power BI Desktop as administrator. If it still doesn't work, please repair your .NET Framework, restart your server and try again to see if it works.

     

    Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Dear v-sihou-msft ,

      It worked for me running as administrator. But is there a way to make it work with a regular user?

      I´m using the admin credentials for SQL connection, but wanted to run PowerBI Desktop with regular user.

      Thank you,

      Eduardo

      • thaslett's avatar
        thaslett
        Advocate I
        8 years ago

        Hello,

        I just wanted to add my experience to this. As the Network Manager, I was not comfortable allowing a user to run with admin credentials, so I wanted to find a way around this issue.

         

        I also did have to use Run As Admin to get the connection to work. I discovered that I only needed to do that to establish the connection, though. Once I did, the program could then be run without the Run As Admin option and it would work.

         

        Hope that helps someone.

    • jcm0733's avatar
      jcm0733
      Regular Visitor
      8 years ago

      Thank you. Run as admin worked for me.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Yes right click and run as administrator solves the problem.  But running the pbix as admin prevents from saving the file on network drive. Thats the only problem. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I had the same problem.

    The "Run as admin" solution or .NET framework repair/new install did not work!

     

    I resolved the issue from inside the pbix file and it was due to the automatic chnages applied in the report data source settings.

    Cleared all the permissions for the data sources that had this problem (some of them were with "Windows" credentials and "Organizational" privacy level). Then, set the Credentials to Windows again with the current user authentication and privacy level to "None", all the Credentials encrypted. It worked, finally!

     

    Hope this helps 🙂 

    • rynhowl's avatar
      rynhowl
      Microsoft Employee
      4 years ago

      I tried all the other solutions mentioned, this is the only one that worked for me.

  • SiWill2017's avatar
    SiWill2017
    Frequent Visitor
    9 years ago

    I am having issues connecting to our SQL server, our CRM is RDB Pro Net, does anyone use the same CRM and had issues connecting to the database?

     

    Thanks.

  • kmuchai's avatar
    kmuchai
    New Member
    7 years ago

    I had the same problem on my installation but only after I had installed the Microsoft Store version of Power BI Desktop. The only way I could get an SQL Database to connect as a data source was to run Power BI as administrator as mentioned by others on this thread. I uninstalled the Microsoft Store version of Power BI and pulled a manual download from the Microsoft Power BI page here :

     

    https://powerbi.microsoft.com/en-us/downloads/  (*Make sure to select the Advanced Download Option to manually pull an installable file)

     

    I've had no issues connecting to my databases since and I do not run Power BI Desktop as administrator. Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    This issue of “impersonation level” can be resolved by runing Power BI Desktop as administrator before accessing the report. After opening the report in Power BI Desktop being ran as an administrator, it may ask for the encrypion aletrt sometimes.

     

    Start > Power BI > right click > select Run as Administrator

    See more details:

    https://natechamberlain.com/2019/02/12/power-bi-refresh-error-could-not-load-file-or-assembly-provided-impersonation-level-is-invalid/

     

  • connect's avatar
    connect
    Resolver I
    3 years ago

    Hi, 
    I also encountred the same issue. However, solution is quite simple. 
    Please run your Power BI Desktop as an Administrator. This will solve this issue. 


    Please let me know if this solves your issue. For me, it worked perfectly.