Remove From My Forums

Selecting the port on which to connect to a PostgreSQL database

Question
0

Sign in to vote

Cheers,

I'm attempting to connect to a PostgreSQL database source with Power Query - but leveraging a different than the standard port. Is it possible to set the port to connect on with Power Query? And if not - where could I actually edit that setting?

Thanks a lot & best regards from Hamburg,

Bjoern

Monday, February 24, 2014 2:14 PM

Reply

|

Quote

Answers

0

Sign in to vote
I'm afraid this isn't currently possible, but it's very much on our radar and we're hoping to enable this scenario before summer.
- Proposed as answer by Miguel.LlopisMicrosoft employee Friday, February 28, 2014 6:37 AM
- Marked as answer by Miguel.LlopisMicrosoft employee Friday, February 28, 2014 6:37 AM
Monday, February 24, 2014 3:08 PM

Reply

|

Quote

All replies

0

Sign in to vote
I'm afraid this isn't currently possible, but it's very much on our radar and we're hoping to enable this scenario before summer.
- Proposed as answer by Miguel.LlopisMicrosoft employee Friday, February 28, 2014 6:37 AM
- Marked as answer by Miguel.LlopisMicrosoft employee Friday, February 28, 2014 6:37 AM
Monday, February 24, 2014 3:08 PM

Reply

|

Quote
0

Sign in to vote

Hi Curt,

Is the feature available now? Can we connect to a mysql port with powerquery.

Thanks and Regards,

Venu

Thursday, August 14, 2014 8:23 AM

Reply

|

Quote
0

Sign in to vote

Hi Venu,

as this thread is about PostgreSQL and not MySQL, you might want to start out here: Connecting Power Query and MySQL

Thursday, August 14, 2014 8:35 AM

Reply

|

Quote
0

Sign in to vote

I don't believe it's possible to set a port for MySQL either, yet.

Thursday, August 14, 2014 1:29 PM

Reply

|

Quote
0

Sign in to vote

Yesterday's release of Power Query enables this functionality. Simply specify the server as servername:portnumber and it should work.

Wednesday, April 15, 2015 2:54 AM

Reply

|

Quote