Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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/
Solved! Go to Solution.
Hi @ysalih ,
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 _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
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.
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?
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...
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
37 | |
27 | |
17 | |
16 | |
8 |
User | Count |
---|---|
45 | |
38 | |
34 | |
18 | |
16 |