postgres.database.azure issue connecting with power bi

[ysalih]

i cant connect power bi with postgres.database.azure : 

error :

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)'Hide details
Activity ID: 8f9a1a82-6633-4d2c-b8fb-1ef4bf852440
Request ID: 2d20805c-1978-9581-f087-972f4d988dfb
Status code: 400
Time: Mon Sep 11 2023 01:48:33 GMT+0300 (Arabian Standard Time)
Service version: 13.0.21509.81
Client version: 2309.1.15569-train
Cluster URI: https://wabi-east-asia-b-primary-redirect.analysis.windows.net/

 

 

[sergej_og]

But it doesn´t work, right?
Look, from Power BI Service´s point of view "everything" not in your PBI tenant is on-prem.
Meaning: when PBI Service don´t see any sources within Service network these sources are not reachable for Service.
Your organizational network as well azure cloud environment are foreign networks which are accessable through a gateway. Azure and Power BI are MS product but they are "not in the same box".

That´s what I have seen until today. You will need a gateway in most cases.
Maybe you have another experiences but that´s what I saw a lot of times.

And my cloud sources are accessable and work properly using a gateway.

Regards.

[bobbyiliev]

A gateway definitely sounds like a workaround. But I want to be able to use the native solution for databases that are publically accessible, a gateway should only be needed for databases running on private networks as clearly stated in the docs. I don't want to have to maintain a server as a gateway and pay the extra bandwidth for all the data to go through it.

[ysalih]

hi @GilbertQ  ,, more info about this issue please

[GilbertQ]

Hi @ysalih 

It looks like it could be an issue with the underlying connection. I would suggest using your Gateway if you can.

If not then the only alternative is a support ticket?

[bobbyiliev]

The server is public and it was working fine last week and I am still able to access it from all other tools including Power BI Desktop, it is only Power BI Service that does not work. It definitely does not sound like a connection issue but a Power BI Service problem, the same thing happened after another major version upgrade on their side a couple of years ago as discussed in an old thread here with the same error but for V 4.0.0.0 rather than V 5.0.0.0 as it is now:

> https://community.fabric.microsoft.com/t5/Service/Could-not-load-file-or-assembly-System-Runtime-Com...