Forum Discussion

alfredomar's avatar
alfredomar
Regular Visitor
8 years ago
Solved

PowerBi SQL server conection

Hi,   I try to connect powerbi desktop to my sql network server(2008)( and always appear the next error:   Detalles: "Se produjo un error al leer datos desde el proveedor: 'No se puede cargar el ...
  • alfredomar's avatar
    alfredomar
    8 years ago

    Hello!!

     

    I try to connect the desktop to my network SQL server 2008 and always appear the next error:

     

    Detalles: "Se produjo un error al leer datos desde el proveedor: 'No se puede cargar el archivo o ensamblado 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' ni una de sus dependencias. No se ha proporcionado el nivel de representación necesario o el nivel de representación no es válido. (Excepción de HRESULT: 0x80070542)'"

     

    I try the windows and sql server login, and always the same.

     

    The server works ok with other apps.

     

    What can I do?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi!!

Try enter Power BI by left click as "Execute as Administrator", 

 

Open Edit queries => Choose every table and check that the source is the same for SQL Server (Server, Database name, port..):

 

 

It happend to me and that was the solution.

The Table 1 was:

= Sql.Database("SBMDEAGSQL04,1454", "DW_DDS")

 

The Table 2 was:

= Sql.Database("SBMDEAGSQL04", "DW_DDS")

 

I added the port 1454.

  • marcbraut's avatar
    marcbraut
    New Member
    5 years ago

    Hi,

     

    Thanks for the information, for me is working the query executing with elevated rights "Execute as Administrator".

    The issue is that i don't have any diference on the tables between "Execute as Administrator" vs Normal...

     

    the query only works when I executed as Administrator and I guees it will not work from a PBI Report server.

     

    Thanks,