Forum Discussion
Helper IPower BI scheduled update issues
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
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
5 Replies
sergej_ogSuper User
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
- aj1973
Community Champion
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...
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...
