Forum Discussion
Gateway Connection Problem
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
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.
4 Replies
- lbendlin
Super User
something is wrong with the plat_vendas table or with the access to that table for the gateway connection user.
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.
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.
