Can't connect to DB Azure Postgres

[badkor3434]

Hello!

I have a problem with connect to my Azure Postgres. When I try connect to DB I see error: "Не удалось обновить учетные данные источников данных: An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.'"

Also, some information. I have already managed to connect this Database to another PowerBi account. The database and that old account were registered on the same organization domain. I thought that this might be the case and tried to create a new database on the domain where I have now created a new PowerBI account, however I am seeing the exact same error.

Help me, please!

[Sreekanth1996]

"I am also facing the same issue. Someone mentioned that engineers are working on cloud connections, but I have been experiencing this issue for a long time. Currently, I refresh the data in Power BI Desktop and publish it daily.
Someone told me that we should see the OAuth2 option in the authentication method, but I am unable to see it. I only see the Basic option. Can anyone please help me?"
 

[Sreekanth1996]

 My data source is PostgreSQL, and it's cloud-based

[badkor3434]

you see same error? Now this problem are solved, my connection are working again

Which DB provider you using?

[v-jianpeng-msft]

Hi, @badkor3434 and @jost and @Givi 

Here's what you can do to alleviate the current problem:

 reusing an existing shared Cloud connection to connect to PostgreSQL, creating and sharing cloud data sources in the Power BI service, creating a new connection in Dataflows and using this new connection while connecting to PostgreSQL, and creating a connection using a Data Gateway.

Best Regards

Jianpeng Li

[badkor3434]

or you mean I need try local gate way?

[badkor3434]

Hi, bro! I was try work with Data Flow. I created new WorkSpace in my Power BI online it's ok - I see data in this space. But when I try create reports in Power BI desktop  - I don't see data 

[v-jianpeng-msft]

Hi, @badkor3434 

I create a dataflow and immediately connect to it in Power BI desktop, again without showing the data:

You'll need to refresh this dataflow in the Power BI service before connecting it in Power BI desktop:

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[badkor3434]

Yes, now it's clear, it's working, thank you. But it's working just if I do manual refresh. When I try setup auto refresh I see same problem when I was setup Virtual Gateway

[v-jianpeng-msft]

Hi, @badkor3434 

Engineers are working on a fix for scheduled refreshes of Azure Postgres, and you can temporarily replace it with manual refreshes.

Best Regards

Jianpeng Li

[badkor3434]

Ok, thanks. When engineers fix that?

[v-jianpeng-msft]

Hi, @badkor3434 and @jhh-cphd 

At the moment, the team is testing the solution, and you need to be patient and trust that it will be back to work soon.

Best Regards

Jianpeng Li

[Givi]

I have same problems....

[v-jianpeng-msft]

Thank you lbendlin 

Hi, @badkor3434 

Your current questions is a known issue and engineers are currently working on a Can't connect to DB Azure Postgres issue. If there is any progress on a fix for this issue, I will update you here.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DanielBrigital]

We are having the same issue with two of our clients data pipelines, major outage stopping company operations. 

Can we please have an update??

[jhh-cphd]

Dear @v-jianpeng-msft ,

Thank you for your answers. 

Do you have an estimated timeline for when the issue might be resolved?

Kind regards,

Jon 

[jost]

Are you aware how urgent this is? Nobody can change or activate refresh policys in semantic models for postgresql connections. This is insane!

[lbendlin]

This is not Report Server related, right?

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .