topic Re: Can't connect to DB Azure Postgres in Report Server

Can't connect to DB Azure Postgres

badkor3434 — Thu, 19 Sep 2024 11:21:41 GMT

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!

Re: Can't connect to DB Azure Postgres

lbendlin — Thu, 19 Sep 2024 14:11:12 GMT

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 .

Re: Can't connect to DB Azure Postgres

Anonymous — Fri, 20 Sep 2024 01:46:56 GMT

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.

Re: Can't connect to DB Azure Postgres

Givi — Fri, 20 Sep 2024 06:50:17 GMT

I have same problems....

Re: Can't connect to DB Azure Postgres

jost — Fri, 20 Sep 2024 08:36:09 GMT

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

Re: Can't connect to DB Azure Postgres

Anonymous — Mon, 23 Sep 2024 02:52:14 GMT

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

Re: Can't connect to DB Azure Postgres

badkor3434 — Mon, 23 Sep 2024 09:46:48 GMT

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

Re: Can't connect to DB Azure Postgres

badkor3434 — Mon, 23 Sep 2024 09:51:02 GMT

or you mean I need try local gate way?

Re: Can't connect to DB Azure Postgres

Anonymous — Mon, 23 Sep 2024 10:15:20 GMT

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.

Re: Can't connect to DB Azure Postgres

badkor3434 — Mon, 23 Sep 2024 10:49:58 GMT

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

Re: Can't connect to DB Azure Postgres

Sreekanth1996 — Mon, 23 Sep 2024 14:52:35 GMT

"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?"

Re: Can't connect to DB Azure Postgres

Sreekanth1996 — Mon, 23 Sep 2024 14:54:59 GMT

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

Re: Can't connect to DB Azure Postgres

Anonymous — Tue, 24 Sep 2024 01:31:20 GMT

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

Re: Can't connect to DB Azure Postgres

badkor3434 — Tue, 24 Sep 2024 11:41:07 GMT

Ok, thanks. When engineers fix that?

Re: Can't connect to DB Azure Postgres

Anonymous — Tue, 24 Sep 2024 13:13:33 GMT

Dear Anonymous ,

Thank you for your answers.

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

Kind regards,

Jon

Re: Can't connect to DB Azure Postgres

Anonymous — Wed, 25 Sep 2024 01:29:12 GMT

Hi, badkor3434 and Anonymous

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

Re: Can't connect to DB Azure Postgres

DanielBrigital — Fri, 27 Sep 2024 13:43:16 GMT

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

Can we please have an update??

Re: Can't connect to DB Azure Postgres

badkor3434 — Mon, 30 Sep 2024 13:44:41 GMT

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

Which DB provider you using?

Re: Can't connect to DB Azure Postgres

Lemi — Tue, 14 Jan 2025 14:34:15 GMT

Anonymous Are there any news about solution? i am facing the same issue

Re: Can't connect to DB Azure Postgres

Lemi — Tue, 14 Jan 2025 14:39:02 GMT

badkor3434 what do you mean by fixed? i have the same issue. cant connect via cloud connection