topic Re: On-premise PostgreSQL data into MS Fabric Lakehouse in Pipelines

On-premise PostgreSQL data into MS Fabric Lakehouse

FraLe — Thu, 20 Jun 2024 14:20:07 GMT

Hi,

I'm researching the possibility to ingest data from an on-premise PostgreSQL database into a MS Fabric Lakehouse, if needed through a Power BI Gateway.

From this source, Copy data From PostgreSQL - Azure Data Factory & Azure Synapse | Microsoft Learn , it seems it can not be done with Fabric and a PBI Gateway.

However, this source, Power Query PostgreSQL connector - Power Query | Microsoft Learn , suggests it can be done via Power Query online and a PBI Gateway.

Can it be done?

Re: On-premise PostgreSQL data into MS Fabric Lakehouse

NandanHegde — Fri, 21 Jun 2024 04:00:46 GMT

Based on my understanding, gateways are now supported within data pipelines.

So you should be able to access the PostGre database via gateway within data pipeline

Re: On-premise PostgreSQL data into MS Fabric Lakehouse

v-cboorla-msft — Mon, 24 Jun 2024 06:02:17 GMT

Hi FraLe

Thank you.

Re: On-premise PostgreSQL data into MS Fabric Lakehouse

v-cboorla-msft — Mon, 01 Jul 2024 05:35:22 GMT

Hi FraLe

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. If you have any question relating to the current thread, please do let us know and we will try out best to help you. In case if you have any other question on a different issue, we request you to open a new thread.

Thank you.

Re: On-premise PostgreSQL data into MS Fabric Lakehouse

FraLe — Mon, 01 Jul 2024 07:03:41 GMT

Thx for the hint.

Re: On-premise PostgreSQL data into MS Fabric Lakehouse

v-cboorla-msft — Mon, 01 Jul 2024 07:05:35 GMT

Hi FraLe

Glad that your query got resolved.
Please continue using Fabric Community for further queries.

Thank you.