Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
nosko
Regular Visitor

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?

 

 

nosko_0-1694521778587.png

nosko_1-1694521796985.png

 

 

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

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

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.

View solution in original post

6 REPLIES 6
v-zhangti
Community Support
Community Support

Hi, @nosko 

 

There is a fix that will begin to be deployed in the near future. Microsoft Fabric Support and Status | Microsoft Fabric

 

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.

v-zhangti
Community Support
Community Support

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.

nosko
Regular Visitor

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.

Ahak
Frequent Visitor

I have also the same issue. Many thanks. 

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

bobbyiliev
Frequent Visitor

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-Com...

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors