Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Nicolas_DHONT
Regular Visitor

Offline mode for Fabric Data Factory in case of internet cuts ?

Hello,

My client is using OnPremise transactional systems (ERP Microsoft Dynamics 365 Business Central and other tools) as they have a lot of web access troubles (due to their location [their factories and shops are on an island], they don't a a goog internet network).

 

They plan to move to Fabric for their BI (They can accept a delay if data are not up-to-date for a couple of days due to internet cut).

But they are wondering if they can use Fabric Data Factory to synchronize their OnPremise tools together too (i.e. ERP and CRM...) Here they cannot accept delays in the synchronisations in case of internet cut.
They got a proposal from Talend and Informatica to run the flows in SaaS mode by creating a local instance on their network so that the communcation can run in case of internet cut.
Do you know if we have similar technoly in Data Factory?

If not, what can Microsoft offer? SSIS?

Thanks and best regards,
Nicolas

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

Hi @Nicolas_DHONT ,

Microsoft Fabric Data Factory can indeed help with synchronizing on-premises tools like ERP and CRM systems. To achieve this, you can use the On-Premises Data Gateway.

This gateway allows you to securely connect your on-premises data sources to Microsoft Fabric, enabling data integration even when your systems are not directly connected to the internet.

 

Here are the specific steps to follow:

1. First you can download and install the gateway.

vyilongmsft_0-1727227342442.png

2. Set up the connection for the on-premise data source in Data Factory.

vyilongmsft_1-1727227445173.png

vyilongmsft_2-1727227504420.png

3. Finally you can connect the gateway to the Data Factory and get the data source.

vyilongmsft_3-1727227602033.png

vyilongmsft_4-1727227849747.png

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous
Not applicable

Hi @Nicolas_DHONT ,

Yes, official documentation does exist, you can refer to this document below, I hope it helps you.

How to access on-premises data sources in Data Factory - Microsoft Fabric | Microsoft Learn

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi @Nicolas_DHONT ,

Microsoft Fabric Data Factory can indeed help with synchronizing on-premises tools like ERP and CRM systems. To achieve this, you can use the On-Premises Data Gateway.

This gateway allows you to securely connect your on-premises data sources to Microsoft Fabric, enabling data integration even when your systems are not directly connected to the internet.

 

Here are the specific steps to follow:

1. First you can download and install the gateway.

vyilongmsft_0-1727227342442.png

2. Set up the connection for the on-premise data source in Data Factory.

vyilongmsft_1-1727227445173.png

vyilongmsft_2-1727227504420.png

3. Finally you can connect the gateway to the Data Factory and get the data source.

vyilongmsft_3-1727227602033.png

vyilongmsft_4-1727227849747.png

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @Anonymous ,

 

Thank you for your reply. I was not aware the gateway was able to run a fabric flow even if it is not able to reach Fabric service due to an internet cut. How does it work technically?

Do you have some documentation about that? (I didn't get find anything on Ms Learn regarding this topic (and my client is asking proof).

 

Thank you for your help!

Anonymous
Not applicable

Hi @Nicolas_DHONT ,

Yes, official documentation does exist, you can refer to this document below, I hope it helps you.

How to access on-premises data sources in Data Factory - Microsoft Fabric | Microsoft Learn

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin
Super User
Super User

The thing that comes to mind is Power BI Report Server.  That's the on-prem equivalent of the Power BI service.

 

I cannot see a future for PBIRS inside Fabric though - they are kind of opposites.

Helpful resources

Announcements
Fabric July 2025 Monthly Update Carousel

Fabric Monthly Update - July 2025

Check out the July 2025 Fabric update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors