Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to 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
@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.
@Anonymous,
You have solved this issue, right? If so, may I close this thread?
Regards,
Lydia
@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.
@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.
@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
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |