Set up Power BI Gateway Error (Connection PostgreSQL)

[Anonymous]

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

[Anonymous · Accepted solution]

 @Anonymous,

According to the above error message, the issue is related to .Net Framework config file. 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-file-error/

Regards,
Lydia

[Anonymous]

@Anonymous Yes, You can.

[Anonymous]

@Anonymous,

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

Regards,
Lydia

[Anonymous · Accepted solution]

@Anonymous Thank you for your advice,  I know for the solution in this case.  Add IP address in the server config to PostgreSQL DB. 

[Anonymous]

@Anonymous  Last Error

[Anonymous]

@Anonymous 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.

[Anonymous]

@Anonymous Thank you, when I try to config I will tell you later.

[Anonymous · Accepted solution]

 @Anonymous,

According to the above error message, the issue is related to .Net Framework config file. 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-file-error/

Regards,
Lydia