Extract data from Fabric

[oskark]

Hi!

I have a customer who wants to retrieve their data from Fabric. There are a couple of solutions for extracting data to an Azure SQL database or Azure ADLS. However, the customer is not currently using Azure and likely wants to store the data on-premises again.

Two solutions I think they would prefer are either to get the data back to their on-premises database or to build their own web UI to display their data.

So my questions are:

1. Has anyone tried to get the data back on-premises? What is your experience, and what are the pros and cons?
2. Has anyone used the Fabric APIs to extract data from Fabric and built their own custom UI? What is your experience, and what are the pros and cons?

Regards,
Oskar

[v-veshwara-msft]

Hi @oskark ,

We just wanted to follow up one last time to check if everything has been resolved on your end. If you’re still facing issues or need any further assistance, please don’t hesitate to reach out—we’re always happy to help.

Thanks again, and we hope all is well!

Best regards,
Vinay.

[v-veshwara-msft]

Hi @oskark ,

We just wanted to check in again regarding your issue. If you’ve found a solution, marking the reply as the solution and leaving a kudos would be greatly appreciated, it helps the community and others with similar questions.

If you’re still facing challenges or have further questions, please let us know we’re here to help and would love to assist you in resolving this.

Looking forward to hearing back from you!

Best regards,
Vinay.

[v-veshwara-msft]

Hi @oskark ,
We haven’t heard back since our last response and wanted to check if your query has been resolved. If not, please feel free to reach out for further assistance. If it has been resolved, kindly mark the helpful reply as the solution to make it easier for others to find. A kudos would also be greatly appreciated!
Thank you.

[v-veshwara-msft]

Hi @oskark 
Thanks for using Microsoft Fabric Community Forum.
As suggested by @NandanHegde , using Copy Data Activity in Fabric can be used to Export data from Fabric to on-premises effectively and securely using On-Premises Data Gateway.
Here are the Pros and Cons of Copy Data Activity:

Pros:

• Automation: Automates the data transfer process, reducing manual effort.

• Reliability: Ensures data consistency and integrity during transfer.

• Scalability: Can handle large volumes of data efficiently.

• Integration: Seamlessly integrates with on-premises data gateways for secure data transfer.

• Schedule and Monitor: Schedule the pipeline to run at regular intervals and monitor its performance to ensure data is transferred correctly.

Cons:

• Setup Complexity: Requires initial setup and configuration of data pipelines and on-premises data gateways.

• Maintenance: Ongoing maintenance and monitoring are needed to ensure smooth operation.

• Cost: Costs associated with data gateway licenses and infrastructure.
  

Fabric APIs to extract data and built custom UI:

To extract data using Fabric APIs and build a custom UI, begin by setting up API access and obtaining the necessary credentials. Familiarize with the Fabric REST API documentation to understand the available endpoints and methods.

The next step involves using the APIs to extract data from Fabric, storing it in a suitable format such as JSON or CSV. Once the data is ready, develop a custom web UI using frameworks like React, Angular, or Vue.js to display the information in a user-friendly manner. Finally, deploy the custom UI to ensure it meets the desired requirements

Pros and Cons:

Pros:

• Customization: Allows for complete customization of data extraction and UI design.

• Flexibility: Can tailor the solution to specific business needs and requirements.

• Control: Provides full control over data processing and presentation.

Cons:

• Development Effort: Requires significant development effort and expertise in API integration and web development.

• Maintenance: Ongoing maintenance and updates are needed to keep the custom UI functional and secure.

• Complexity: Can be complex to implement and manage, especially for non-technical users.
  

Hope the above points may answer your doubts regarding Copy Data and Fabric APIs.
If you need assisatnce setting up please reach out.

If this post helps, please accept whichever solution meets your needs and a kudos would be appreciated.

Thanks and Regards.

[oskark]

Thanks for mentioning the data gateway, I thought I had to use that one. I think the source of my data will be the Lakehouse in Fabric, I have not decided yet.

[NandanHegde · Accepted solution]

There is a direct connector in data pipelines in fabric to access lakehouse, so that should work to copy the data

[NandanHegde]

You can use Data pipeline copy activity to copy data from fabric environment (lakehouse, fabric warehouse/database etc) into On Prem but you would need an on Prem data gateway to accomplish that.

When you say extract data from Fabric, can you plz specify what is the source of your data?