Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

 

Gateways

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

     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's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous Thank you, when I try to config I will tell you later.:smileyvery-happy:

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous  Last Error

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago


    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's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous,

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

    Regards,
    Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous Yes, You can.