Skip to main content
cancel
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

Reply
ysalih
Frequent Visitor

postgres.database.azure issue connecting with power bi

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/

adsfvwe.png

Screenshot 2023-09-11 084831.png

1 ACCEPTED SOLUTION
v-rongtiep-msft
Community Support
Community Support

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.

View solution in original post

25 REPLIES 25

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.

ysalih
Frequent Visitor

hi @GilbertQ  ,, more info about this issue please

 
 
GilbertQ
Super User
Super User

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.