Forum Discussion

nosko's avatar
nosko
Regular Visitor
2 years ago
Solved

Unable to connect app.powerbi.com to postgresql

Hello everyone
I ran into a problem connecting to my postgre server.
In the desktop version, everything is updated and loaded normally. The security certificate on the database server is ok. But after uploading the report to the cloud, updates do not work.
They write on the Internet that this problem is related to application errors, but 2 days ago everything worked like clockwork. Screenshots with errors are attached.
What could be the problem?

 

 

 

 

An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)'

 

ActivityId: dba4bc54-f9ce-4be5-920b-89d468ebf2e3

RequestId: 5351e5a7-ab63-4464-bc23-2f6951963c25

Need Help
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, nosko 

     

    Have submitted this issue internal to confirm, would update here as soon as possible if there is any update about it.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

7 Replies

  • Ahak's avatar
    Ahak
    Frequent Visitor
    2 years ago

    I have also the same issue. Many thanks. 

    • bobbyiliev's avatar
      bobbyiliev
      Frequent Visitor
      2 years ago

      Seems like quite a few people are hitting the problem. I'm still seeing this and have not been able to make any progress. 

  • v-zhangti's avatar
    v-zhangti
    Community Support
    2 years ago

    Hi, nosko 

     

    Have submitted this issue internal to confirm, would update here as soon as possible if there is any update about it.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • jmsoler7's avatar
      jmsoler7
      Regular Visitor
      2 years ago

      Still failing as of March 2024. Is there any new information about that?

  • bobbyiliev's avatar
    bobbyiliev
    Frequent Visitor
    2 years ago

    I am also facing the exact same problem for my Postgres instance. It was all working last week and over the weekend it stopped, as far as I can tell it might be related to the most recent update to Version 5.0.0.0.

    Failed to update data source credentials: An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)'

     

    I came across the same problem reported a few years ago after the upgrade to Version 4.0.0.0 here:

    > https://community.fabric.microsoft.com/t5/Service/Could-not-load-file-or-assembly-System-Runtime-CompilerServices/m-p/1481902/page/2

  • nosko's avatar
    nosko
    Regular Visitor
    2 years ago

    For now, the only solution is the gateway.

    I installed on a separate Windows server and started connecting to postgress.

    There is no need for a certificate but you need install npgsql and gacutil from the visual studio package on gateway server.