Postgre SQL x Power BI - System.Runtime.CompilerServices.Unsafe

[PriscilaOTito]

Não consigo mais conectar dados a vindos de banco PostgreSQL. Vide abaixo o erro que recebo:

[zefgzeerzgzergz]

Just to let you know, you're not alone

https://learn.microsoft.com/en-us/answers/questions/1571930/an-error-happened-while-reading-data-fro...

[Anonymous]

Hi @PriscilaOTito ,

Here are some general steps you can take to try to resolve the issue:

1. Check that the Npgsql provider is installed and updated.

2. Check connection settings: Ensure that the server and database information provided is correct and that the PostgreSQL instance allows Power BI to connect.

3. Check Firewall and Network Settings: If PostgreSQL is hosted in an environment other than Azure, ensure that the database is configured to allow Internet connections and that no firewalls are blocking connections.

Best Regards,

Neeko Tang

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

[PriscilaOTito]

Olá! Ainda não foi resolvido o problema.

Testei todos os itens e nada funcionou. 
Testei inclusive a conexão em outra rede e conectou normalmente. 
Atualizei meu Power BI para ficar na mesma versão do que conseguimos conectar em outra rede mas nada funcionou. Se tiver alguma outra sugestão ficarei grata.

Att, 

[Anonymous]

Hi @PriscilaOTito ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.

Best Regards,

Neeko Tang

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

[PriscilaOTito]

Olá! Ainda não foi resolvido o problema

Creio que seja alguma particularidade da máquina que estou usando, pois tentei conectar em outras máquinas  e conecta normalmente. 

Obrigada pelo apoio!

[Anonymous]

Hi @PriscilaOTito ,

I found two similar posts, can you refer to them to see if the solution applies to you?

An error happened while reading data from the prov... - Microsoft Fabric Community

Can't connect to posgresql databases - Microsoft Fabric Community

Best Regards,

Neeko Tang

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