topic Re: Generate table based on CSV and on-premise Data in Data Engineering

Generate table based on CSV and on-premise Data

joshua1990 — Sun, 27 Apr 2025 08:03:44 GMT

Hi all!

I would like to generate a table that contains historical information for the last 10 years using CSV files and a dataflow that is linked to a on-premise server. This view from the server gets updated every month.

How would you do that?

Store CSV in Sharepoint and consolidate using dataflow and then build a table based on both dataflows?

Or would you store CSV in Onelage and to something in there?

Re: Generate table based on CSV and on-premise Data

lbendlin — Sun, 27 Apr 2025 15:14:50 GMT

If you already have CSV files you don't need a dataflow. Keep ingesting them directly into your semantic model.

If you are considering OneLake or Fabric then another option would be to convert the CSVs to Parquet. Then you could access them via Direct Lake connection.

Re: Generate table based on CSV and on-premise Data

ucarbengisu — Tue, 29 Apr 2025 07:29:51 GMT

I would upload the historical CSV files to OneLake. To bring in current data, I would connect the on-premises SQL Server using a Data Gateway, loading the data into the same Lakehouse or dataflow environment. Once both historical and current data are available, you can union and store the results as a delta table or a Warehouse table, allowing for scalable, long-term querying.

I think this method is well-suited for large datasets, as OneLake offers better performance and scalability compared to SharePoint. It also provides unified storage, meaning all your data resides in a single, centralized environment, which simplifies data management. With delta format support, this setup is ideal for incremental data processing and advanced analytics. Additionally, it is more future-proof, since the data can easily integrate with other Fabric capabilities such as Spark and SQL analytics tools.

Re: Generate table based on CSV and on-premise Data

Anonymous — Fri, 02 May 2025 11:56:24 GMT

Hi @joshua1990,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

Re: Generate table based on CSV and on-premise Data

Anonymous — Mon, 05 May 2025 11:39:20 GMT

Hi @joshua1990,

Regards,
Vinay Pabbu

Re: Generate table based on CSV and on-premise Data

Anonymous — Thu, 08 May 2025 12:14:03 GMT

Hi @joshua1990,

Regards,
Vinay Pabbu