Unable to connect Supabase to Power BI - SCRAM Error

[gbsafonso]

Olá, estou com problemas para conectar o Supabase ao Power BI no meu laptop.

Recebo esta mensagem de erro:

PostgreSQL: Assinatura do servidor não recebida na mensagem final do servidor SCRAM

O estranho é que a mesma configuração funciona perfeitamente no computador do meu colega. Usamos as mesmas credenciais, string de conexão e drivers.

Já tentei atualizar o driver ODBC do PostgreSQL e verificar as configurações de SSL e autenticação do meu sistema, mas ainda não funciona.

Alguém sabe o que pode estar causando esse problema? Pode ser algo específico da minha máquina?

Obrigado!

[gbsafonso]

So, I already tried to download Npgsql and the ODBC x64 driver, but it didn’t work. I’m not sure if I did something wrong, and I don’t really have any step-by-step guide to follow, so I’m kind of lost. Honestly, I have no idea if I installed it correctly.

[v-sdhruv · Accepted solution]

Hi @gbsafonso ,

Aditionally, you can even check:

1. If you are using the  correct version of the Npgsql driver

2. Try disabling SSL temporarily to test if the issue is SSL-related.

Refer-
How to connect to Supabase
https://supabase.com/docs/guides/database/connecting-to-postgres


Hope this helps!

[gbsafonso]

So, I already tried to download Npgsql and the ODBC x64 driver, but it didn’t work. I’m not sure if I did something wrong, and I don’t really have any step-by-step guide to follow, so I’m kind of lost. Honestly, I have no idea if I installed it correctly.

[amitchandak]

@gbsafonso , Please check the version of Power BI Desktop. There was a new enhancement a couple of months back for the PostgreSQL driver. Check if this does not work with the latest version