Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I get this error when setting up a new datasource to PostgreSQL in my Gateway in the Service:
"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.
Status code: 400
Error Code: DMTS_PublishDatasourceToClusterErrorCode
p-gateway: Unable to connect to the data source undefined.
Underlying error message: Please install Npgsql version 4.0.10.0 or earlier."
I did install Npgsql 4.0.10.0, restarted everything but it doesn't work.
Please help
Solved! Go to Solution.
OK
I've solved the problem installing Npgsql 4.0.10 WITH GAC(!!!)
When installing, make sure that you select NpgSQL GAC Installation.
This GAC did the trick.
Then reboot the machine.
Good luck!
Hi.
1° Install NGPSQL:
https://github.com/npgsql/npgsql/releases/tag/v4.0.10
2° Reboot On-premises data gateway.
Its solved for mi.
Hmm, these ones are tough to troubleshoot. You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
OK
I've solved the problem installing Npgsql 4.0.10 WITH GAC(!!!)
When installing, make sure that you select NpgSQL GAC Installation.
This GAC did the trick.
Then reboot the machine.
Good luck!
Hi @michaelshparber I instalded the Npgsql 4.0.10 with NpgSQL GAC installation,and reboot the machine ,but it still doesn't work when connetting getway and postgreSQL. Please let me know if you have any solutions, that's will be appreciate with your help!
No need to reboot the machine, only Power BI Gateway
How do you install Npgsql 4.0.10 WITH GAC?
Hi,
Could you please explain more on how exactly is to install Npgsql 4.0.10 with GAC?
I've tried to install using stack builder, I could find the npgsql part but I couldn't found the GAC part.
really appreaciate your help!
regards,
@Anonymous
During the installation you should get this screen:
Just check the GAC installation, too.
Hello,
do you have a link to provide for this installer ?
Struggling finding one ....
Thanks
Very late, sorry ... But thanks a lot for the link 😄 Worked perfectly .
FYI here is link to the Windows installation file (MSI):
https://github.com/npgsql/npgsql/releases/tag/v4.0.10
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
39 | |
33 | |
31 | |
25 |