Reply
Highlighted
Frequent Visitor
Posts: 9
Registered: ‎06-15-2016
Accepted Solution

Set up Power BI Gateway Error (Connection PostgreSQL)

Unable to connect: We encountered an error while trying to connect to. Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."

 

I can't set up power bi gateway between  PostgreSQL. this is an error code and descriptions

 

Activity ID:5e8d43d8-e005-4e28-a499-2d5036ccaf1f
Request ID:d6e833c0-3882-5fa7-a90a-4e42d03609de
Cluster URI:https://wabi-south-east-asia-redirect.analysis.windows.net
Status code:400
Error Code:DMTS_PublishDatasourceToClusterErrorCode
Time:Fri Nov 02 2018 10:47:57 GMT+0700 (Indochina Time)
Version:13.0.7149.169
servicespbi_psg:Cannot connect to the mashup data source. See error details for more information.
Underlying error code:-2147467259
Underlying error message:The 'DbProviderFactories' section can only appear once per config file.. This is a configuration issue with the file 'C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config'.
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:PostgreSQL
Microsoft.Data.Mashup.ValueError.DataSourcePath:10.1.1.117:5432;pmf_powerbi
Microsoft.Data.Mashup.ValueError.Reason:DataSource.Error

 

Picture1.png


Accepted Solutions
Moderator
Posts: 9,523
Registered: ‎03-10-2016

Re: Set up Power BI Gateway Error (Connection PostgreSQL)

 @Tichakorn,

According to the above error message, the issue is related to .Net Framework config fiel. Please open machine.config file under C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config,  search DbProviderFactories and delete extra DbProviderFactories section.

There is a similar blog for your reference.

http://laurenthinoul.com/how-to-solve-dbproviderfactories-section-can-only-appear-once-per-config-fi...

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Frequent Visitor
Posts: 9
Registered: ‎06-15-2016

Re: Set up Power BI Gateway Error (Connection PostgreSQL)


@v-yuezhe-msft Thank you for your advice,  I know for the solution in this case.  Add IP address in the server config to PostgreSQL DB.101.png 

View solution in original post


All Replies
Moderator
Posts: 9,523
Registered: ‎03-10-2016

Re: Set up Power BI Gateway Error (Connection PostgreSQL)

 @Tichakorn,

According to the above error message, the issue is related to .Net Framework config fiel. Please open machine.config file under C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config,  search DbProviderFactories and delete extra DbProviderFactories section.

There is a similar blog for your reference.

http://laurenthinoul.com/how-to-solve-dbproviderfactories-section-can-only-appear-once-per-config-fi...

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Moderator
Posts: 9,523
Registered: ‎03-10-2016

Re: Set up Power BI Gateway Error (Connection PostgreSQL) - Status changed to: Delivered

 
Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 9
Registered: ‎06-15-2016

Re: Set up Power BI Gateway Error (Connection PostgreSQL)

@v-yuezhe-msft Thank you, when I try to config I will tell you later.Smiley Very Happy

Frequent Visitor
Posts: 9
Registered: ‎06-15-2016

Re: Set up Power BI Gateway Error (Connection PostgreSQL)

@v-yuezhe-msft I have still the problem, how can do I?

By the way, I try to Power BI Gateway Personal Mode this is an Error Msg.

Picture2.pngPicture3.png

Frequent Visitor
Posts: 9
Registered: ‎06-15-2016

Re: Set up Power BI Gateway Error (Connection PostgreSQL)

@v-yuezhe-msft  Last ErrorPicture5.png

Frequent Visitor
Posts: 9
Registered: ‎06-15-2016

Re: Set up Power BI Gateway Error (Connection PostgreSQL)


@v-yuezhe-msft Thank you for your advice,  I know for the solution in this case.  Add IP address in the server config to PostgreSQL DB.101.png 

Moderator
Posts: 9,523
Registered: ‎03-10-2016

Re: Set up Power BI Gateway Error (Connection PostgreSQL)

@Tichakorn,

You have solved this issue, right? If so, may I close this thread?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 9
Registered: ‎06-15-2016

Re: Set up Power BI Gateway Error (Connection PostgreSQL)

@v-yuezhe-msft Yes, You can.