cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tichakorn Frequent Visitor
Frequent Visitor

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

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

 @Tichakorn,

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-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.
Tichakorn Frequent Visitor
Frequent Visitor

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 

8 REPLIES 8
Moderator v-yuezhe-msft
Moderator

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

 @Tichakorn,

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-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 v-yuezhe-msft
Moderator

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.
Tichakorn Frequent Visitor
Frequent Visitor

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

Tichakorn Frequent Visitor
Frequent Visitor

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

Highlighted
Tichakorn Frequent Visitor
Frequent Visitor

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

@v-yuezhe-msft  Last ErrorPicture5.png

Tichakorn Frequent Visitor
Frequent Visitor

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 v-yuezhe-msft
Moderator

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.
Tichakorn Frequent Visitor
Frequent Visitor

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

@v-yuezhe-msft Yes, You can.