Forum Discussion
Azure PostgreSQL db is not available for Power BI Service
The gateway won't actually help you as it is missing the npgsql ADO driver.
You can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues . If you have a Pro license you can consider raising a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Hello. I am having the same problem.
To be more precise:
* My report's Postgres connection works perfectly fine on Power BI Desktop
* When I try to connect from Power BI Web (i.e, when publishing said perfectly working report), the following error shows up:
'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)'
My guess is that the runtime used by the Power BI Service is either missing NpgSQL or is using an older version of it. For this reason, I bet you wouldn't have the same problem if Postgres was deployed on-premise via a gateway, with the proper drivers installed. This is not a real solution, though, as I shouldn't have to deploy a whole new Windows server in order to use a Postgres DB I already have deployed and accesible in the cloud.
This is a breaking change for every user using Postgres on the cloud (in my case, it is deployed on Linode), I hope they fix this soon.
I will fill attempt to fill a ticket as well.
Cheers
Hi fapomatius,
I have an easier work around - the refresh works when I run it manually, no problem.
Microsoft support engineer informed me yesterday that the product group team is currently investigating the issue.
Best regards,
Pavel