Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |