Gateway Connection Problem

[Evans_Santos]

Good afternoon! I'm facing a problem that has been taking away my peace recently: 2 days ago my Power BI reports started showing the error below, as the problem was specific to the Gateway, I checked its health in my VM and it is operating actively and normally , however when I force an update of the Data Model in the Online service it displays the error below;

I've already restarted my virtual machine, I've uninstalled and reinstalled the Gateway, I've created a new Gateway and new connections to my Database in Power BI online but nothing has had any effect.

My data source comes from a PostgreSQL database.

I'm looking for any kind of help or answer. Thanks.

Erro de fonte de dados: [ValidateMarkupTags]{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"[ccon]PostgreSQL: Exception while reading from stream[/ccon]"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"PostgreSQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"[ccon][ccon]</ip>[/ccon]<ip><ip></ip></ip>;plat_vendas[/ccon]"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"[ccon]Exception while reading from stream[/ccon]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Clientes_Churn.
Cluster URI: WABI-BRAZIL-SOUTH-B-PRIMARY-redirect.analysis.windows.net
ID da atividade: ab25cae2-55c9-4d42-9522-464a020f13a7
Solicitar ID: 683ff3e3-9d0a-6af2-e92c-c8c9cdaad95e
Hora: 2024-08-15 19:16:29Z

[Anonymous · Accepted solution]

Hi, @Evans_Santos 

Check your firewall settings to make sure that there are no firewall rules blocking the connection between the Power BI gateway and the PostgreSQL database. Sometimes, the firewall may drop packets which leads to this error. 
You can try increasing the timeout setting in the Power BI connection string. You can check the following post:

Solved: Postgresql: Exception while reading from stream - Microsoft Fabric Community

Install the npgsql provider to ensure that the npgsql provider is installed on the server that hosts the data gateway. This is required for the PostgreSQL connection to work properly. You can refer to the following post:

Solved: Configure Gateway to connect to PostgreSQL - Microsoft Fabric Community

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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

[Evans_Santos]

How can I check to see if the user has access to the bank? I've tried everything but nothing has worked. I'm waiting if you can help.

[lbendlin]

Talk to your PostGreSQL database admin.

[lbendlin]

something is wrong with the plat_vendas table or with the access to that table for the gateway connection user.