cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
michaelshparber
Helper V
Helper V

Gateway error connecting to PostgreSQL

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

1 ACCEPTED 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!

View solution in original post

9 REPLIES 9
Greg_Deckler
Super User
Super User

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".


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

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!

View solution in original post

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,

@RachimWinata 

During the installation you should get this screen:

Just check the GAC installation, too.

 

Capture.JPG

 

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

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors