Power BI scheduled update issues

[AndresEsteban]

I am having problems scheduling automatic updates in Power Bi. The source of my data is an Azure Database for PostgreSQL table and, until now, I have had no problems scheduling updates, but now it won't let me do it. When in Power BI Service I go to Data source credentials I get a message that the connection with the data source could not be tested, so I try to re-enter the credentials and I get the following error:

The data source credentials could not be updated: 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=xxxxxxxx' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT:

Does anyone know why this is happening and how it could be solved?

Thank you

[v-tangjie-msft · Accepted solution]

Hi @AndresEsteban ,

This issue has been submitted internally. Please be patient to wait for fixing. If there is any news, I will update it here.

------------

update: The issue has been resolved.

Best Regards,

Neeko Tang

[AndresEsteban]

So, is it an internal problem? I'm telling you, it's very strange because just last week everything was working normally and I was able to schedule updates...

[aj1973]

Hi @AndresEsteban 

Maybe this can help you understand how to connect to postgresql

https://learn.microsoft.com/en-us/power-query/connectors/postgresql

[AndresEsteban]

First of all, thank you for your response. The fact is that I don't have any gateway configured since I am using PostgreSQL Database for Azure so they are natively integrated and no configuration is needed...

[sergej_og]

Hey @AndresEsteban ,

do you already use a gateway?

If yes, you can install required driver for your database on it and connect to your data via gateway.

maybe an acceptable solution for you.

regards