Connect to PostgreSQL with Get & Transform in Excel 2016 (Npgsql)

%3CLINGO-SUB%20id%3D%22lingo-sub-80278%22%20slang%3D%22en-US%22%3EConnect%20to%20PostgreSQL%20with%20Get%20%26amp%3B%20Transform%20in%20Excel%202016%20(Npgsql)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-80278%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Folks%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CEM%3EAs%20recomended%20by%20the%20Office%20Support%20page%20(%3CA%20title%3D%22link%22%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FConnect-to-a-PostgreSQL-database-Power-Query-bf941e52-066f-4911-a41f-2493c39e69e4%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Elink%3C%2FA%3E)%2C%26nbsp%3BI'd%20like%20to%26nbsp%3Bstart%20a%20new%20conversation%20on%20how%20to%20ingegrate%20PostgreSQL%20in%20this%20forum%20as%20I%20cant%20find%20(after%202%20hours%20of%20searching)%20any%20simple%20sollutions%20out%20there.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EAm%20tyring%20to%20get%20Excel%20(2016%20Professional%2032%20Bit)%20comunicating%20with%20a%20PostgreSQL%20Server%20and%20what%20is%26nbsp%3Brecomended%20to%20consider%20by%20the%20official%20Support%20Page%20to%20this%20topic%20is%20not%20enough.%3CBR%20%2F%3E%3CBR%20%2F%3EHere%20where%20I%20got%20stuck%20running%20in%20circles.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Err2.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F16147iAF153CB3E30C3EBB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Err2.png%22%20alt%3D%22Err2.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3EOnce%20you%20click%2C%20learn%20more%20you%20get%20back%20to%20the%20Suport%20page.%3CBR%20%2F%3E%3CBR%20%2F%3EAs%20recomended%20by%20the%20Support%20page%2C%20I%20installed%20Npgsql%2C%20restarted%26nbsp%3BExcel%20*(and%20even%20the%20PC)%2C%20...%26nbsp%3Bmade%20sure%20that%20the%20Npgsql%20is%20at%20%22%3CSPAN%3EC%3A%5CWindows%5CMicrosoft.NET%5Cassembly%5CGAC_MSIL%3C%2FSPAN%3E%22%26nbsp%3Band%20still%20am%20not%20getting%20any%20further%20and%20when%20searching%20for%20more%20info%20online%20I%20always%20only%20get%26nbsp%3Breferenced%26nbsp%3Bback%20to%20the%20same%20suport%20page%20(%3CA%20title%3D%22link%22%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FConnect-to-a-PostgreSQL-database-Power-Query-bf941e52-066f-4911-a41f-2493c39e69e4%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%3CI%3E%3CFONT%20color%3D%22%230066cc%22%3Elink%3C%2FFONT%3E%3C%2FI%3E%3C%2FA%3E).%3CBR%20%2F%3E%3CBR%20%2F%3EDoes%20anybody%20know%3A%3CBR%20%2F%3E1.)%20Is%26nbsp%3Bconnecting%20to%20PostgreSQL%20a%26nbsp%3B365%20only%20feature%20%26amp%3B%20if%20yes%2C%20shouldnt%20that%20work%20with%20Get%20%26amp%3B%20Transform%202016%20as%20well%20%3F%3CBR%20%2F%3E2.)%20Anybody%20Ideas%20on%20where%20I%20could%20research%20further%20into%20that%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEdit%2021%2F06%20-%26nbsp%3Ba%20lot%20of%20info%20this%20problem%26nbsp%3Bcan%20also%20be%20found%20at%20following%20page%20-%26gt%3B%20%3CA%20href%3D%22https%3A%2F%2Fsuperuser.com%2Fquestions%2F950100%2Fconnect-to-postgresql-database-from-excel-2013-power-query-with-npgsql%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Elink%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-80278%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-213567%22%20slang%3D%22en-US%22%3ERe%3A%20Connect%20to%20PostgreSQL%20with%20Get%20%26amp%3B%20Transform%20in%20Excel%202016%20(Npgsql)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-213567%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20exactly%20the%20same%20problem%20with%20the%2064-bit%20version.%26nbsp%3B%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F63333%22%20target%3D%22_blank%22%3E%40Elmar%20Bischof%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3EHello%20Folks%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CEM%3EAs%20recomended%20by%20the%20Office%20Support%20page%20(%3CA%20title%3D%22link%22%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FConnect-to-a-PostgreSQL-database-Power-Query-bf941e52-066f-4911-a41f-2493c39e69e4%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Elink%3C%2FA%3E)%2C%26nbsp%3BI'd%20like%20to%26nbsp%3Bstart%20a%20new%20conversation%20on%20how%20to%20ingegrate%20PostgreSQL%20in%20this%20forum%20as%20I%20cant%20find%20(after%202%20hours%20of%20searching)%20any%20simple%20sollutions%20out%20there.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EAm%20tyring%20to%20get%20Excel%20(2016%20Professional%2032%20Bit)%20comunicating%20with%20a%20PostgreSQL%20Server%20and%20what%20is%26nbsp%3Brecomended%20to%20consider%20by%20the%20official%20Support%20Page%20to%20this%20topic%20is%20not%20enough.%3CBR%20%2F%3E%3CBR%20%2F%3EHere%20where%20I%20got%20stuck%20running%20in%20circles.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Err2.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F16147iAF153CB3E30C3EBB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Err2.png%22%20alt%3D%22Err2.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3EOnce%20you%20click%2C%20learn%20more%20you%20get%20back%20to%20the%20Suport%20page.%3CBR%20%2F%3E%3CBR%20%2F%3EAs%20recomended%20by%20the%20Support%20page%2C%20I%20installed%20Npgsql%2C%20restarted%26nbsp%3BExcel%20*(and%20even%20the%20PC)%2C%20...%26nbsp%3Bmade%20sure%20that%20the%20Npgsql%20is%20at%20%22%3CSPAN%3EC%3A%5CWindows%5CMicrosoft.NET%5Cassembly%5CGAC_MSIL%3C%2FSPAN%3E%22%26nbsp%3Band%20still%20am%20not%20getting%20any%20further%20and%20when%20searching%20for%20more%20info%20online%20I%20always%20only%20get%26nbsp%3Breferenced%26nbsp%3Bback%20to%20the%20same%20suport%20page%20(%3CA%20title%3D%22link%22%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FConnect-to-a-PostgreSQL-database-Power-Query-bf941e52-066f-4911-a41f-2493c39e69e4%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%3CI%3E%3CFONT%20color%3D%22%230066cc%22%3Elink%3C%2FFONT%3E%3C%2FI%3E%3C%2FA%3E).%3CBR%20%2F%3E%3CBR%20%2F%3EDoes%20anybody%20know%3A%3CBR%20%2F%3E1.)%20Is%26nbsp%3Bconnecting%20to%20PostgreSQL%20a%26nbsp%3B365%20only%20feature%20%26amp%3B%20if%20yes%2C%20shouldnt%20that%20work%20with%20Get%20%26amp%3B%20Transform%202016%20as%20well%20%3F%3CBR%20%2F%3E2.)%20Anybody%20Ideas%20on%20where%20I%20could%20research%20further%20into%20that%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEdit%2021%2F06%20-%26nbsp%3Ba%20lot%20of%20info%20this%20problem%26nbsp%3Bcan%20also%20be%20found%20at%20following%20page%20-%26gt%3B%20%3CA%20href%3D%22https%3A%2F%2Fsuperuser.com%2Fquestions%2F950100%2Fconnect-to-postgresql-database-from-excel-2013-power-query-with-npgsql%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Elink%3C%2FA%3E%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2027815%22%20slang%3D%22en-US%22%3ERe%3A%20Connect%20to%20PostgreSQL%20with%20Get%20%26amp%3B%20Transform%20in%20Excel%202016%20(Npgsql)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2027815%22%20slang%3D%22en-US%22%3EDid%20you%20solve%20the%20problem%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello Folks :)


As recomended by the Office Support page (link), I'd like to start a new conversation on how to ingegrate PostgreSQL in this forum as I cant find (after 2 hours of searching) any simple sollutions out there.


Am tyring to get Excel (2016 Professional 32 Bit) comunicating with a PostgreSQL Server and what is recomended to consider by the official Support Page to this topic is not enough.

Here where I got stuck running in circles.

Err2.png

Once you click, learn more you get back to the Suport page.

As recomended by the Support page, I installed Npgsql, restarted Excel *(and even the PC), ... made sure that the Npgsql is at "C:\Windows\Microsoft.NET\assembly\GAC_MSIL" and still am not getting any further and when searching for more info online I always only get referenced back to the same suport page (link).

Does anybody know:
1.) Is connecting to PostgreSQL a 365 only feature & if yes, shouldnt that work with Get & Transform 2016 as well ?
2.) Anybody Ideas on where I could research further into that ?

 

Edit 21/06 - a lot of info this problem can also be found at following page -> link

3 Replies

I have exactly the same problem with the 64-bit version. 


@Elmar Bischof wrote:

Hello Folks :)


As recomended by the Office Support page (link), I'd like to start a new conversation on how to ingegrate PostgreSQL in this forum as I cant find (after 2 hours of searching) any simple sollutions out there.


Am tyring to get Excel (2016 Professional 32 Bit) comunicating with a PostgreSQL Server and what is recomended to consider by the official Support Page to this topic is not enough.

Here where I got stuck running in circles.

Err2.png

Once you click, learn more you get back to the Suport page.

As recomended by the Support page, I installed Npgsql, restarted Excel *(and even the PC), ... made sure that the Npgsql is at "C:\Windows\Microsoft.NET\assembly\GAC_MSIL" and still am not getting any further and when searching for more info online I always only get referenced back to the same suport page (link).

Does anybody know:
1.) Is connecting to PostgreSQL a 365 only feature & if yes, shouldnt that work with Get & Transform 2016 as well ?
2.) Anybody Ideas on where I could research further into that ?

 

Edit 21/06 - a lot of info this problem can also be found at following page -> link


 

Did you solve the problem?

Hello.
Yes and No.

Yes: It was recently solved by our IT Department, by them buying the license to have PowerBI Server through which you can also deploy reports as web links to users. At the Server Setup it worked to get it connected straight away.

No: Did never get it to run directly into the Postgres from a PowerBi Pptx file.

Work Arround that I used for a while:
I set up a FTP routine shedule in our reporting software that dumped the data that I needed on to a secured folder on the local drives, where I rolled out the PowerBi file in question. PowerBi has an organisational access validation integrated that enabled those that needed to read the source data in the secured folder. Still a bad & sad workaround in comparison to the server solution, but it works.