Connect to a postgresql database

%3CLINGO-SUB%20id%3D%22lingo-sub-2154008%22%20slang%3D%22en-US%22%3EConnect%20to%20a%20postgresql%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2154008%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20Office%20365%20and%20I%20am%20trying%20to%20connect%20to%20a%20postgresql%20database%2C%20but%20it%20does%20not%20work.%3C%2FP%3E%3CP%3EI%20get%20the%20following%20error%20message%3C%2FP%3E%3CP%3E'%20postgresql%20database%20this%20connector%20requires%20one%20or%20more%20additional%20components'%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20strange%2C%20because%20it%20connects%20beautifully%20on%20PowerBI%2C%20but%20on%20excel%20it%20doesn't%20want%20to%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2154008%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello

 

I am using Office 365 and I am trying to connect to a postgresql database, but it does not work.

I get the following error message

' postgresql database this connector requires one or more additional components'

 

I strange, because it connects beautifully on PowerBI, but on excel it doesn't want to work.

1 Reply

@jon_ugarte 

Power Query Online, for Power BI Desktop and for Excel are bit different. Some functionality available in one version could be not available for others. In particular,

image.png

Power Query PostgreSQL connector | Microsoft Docs

I guess same for Excel (have no practical experience with PostgreSQL), you must install the NpgSQL provider on your local machine.