Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

iamhassaan

Issues connecting to Azure Database for PostgreSQL from PowerBI

Submitted by Advocate I on ‎08-26-2021 01:48 AM

My company has production dashboards that have been effected by some issue between Azure Postgresql PaaS service and PowerBI. Any updates on the fix timeline? 


Processing errorAn error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.1, 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)'

Status: New
See more ideas labeled with:
28 Comments (28 New)
Comments
andyclap
Advocate II
Advocate II
‎08-31-2021 03:00 AM

MS - please update your service page: There is a degredation. 

This is affecting a lot of users, and I see several threads in this forum already. The whole point of a service page is to be the first point of call to see if there are any known problems.

ysanabria
Frequent Visitor
‎08-31-2021 09:44 AM

This is a remedy for now.

 

Install this .msi in the gateway machine and then you can connect your data source by gateway

 

In GitHub you may find it:

Release Npgsql v4.0.10 · npgsql/npgsql · GitHub

andyclap
Advocate II
Advocate II
‎09-02-2021 02:51 AM

Phew, finally seems like it's working again.

 

Thanks to the support team for fixing this.

Let's have some integration tests around connectors for the next release, eh?

 

zenisekd
Super User
Super User
‎09-02-2021 03:14 AM

Same issue here. My workaround at the moment is that every morning I refresh my desktop and publish it again.

ysanabria
Frequent Visitor
‎09-02-2021 10:25 AM

The issue was solved by Microsoft. For me is working now with my direct connection to AZ Postgres

ALWI
Frequent Visitor
‎09-03-2021 02:06 AM

Works again!

@Microsoft pls improve your QA process before you deploy something. The same problem was in the past several times! That will save a a lot of time for so many people.

 

Thx!  

zenisekd
Super User
Super User
‎09-06-2021 11:43 PM

I since yesterday I am having connection errors again (40001). But only with more complex reports. Reports that have only few tables work fine. Anybody else is having same issues?

PakthurYangu
Helper I
Helper I
‎01-22-2024 11:31 AM

I wasted a few days looking for a solution until I came across this article.

In short, you have to install version 4.0.10 of NpgSQL and when installing, select the NpgSQL GAC option. The article I linked has a more detailed step-by-step guide.

Idea Statuses