I’m here today to please request your knowledge about SQL Server.

The issue is: I have sales .CSV files, all of them with the same headers; but, when I load them and transform them in Power Query (Excel / Power BI), it takes too much time to refresh the data, because it loads the entire folder. I cannot do an incremental refresh because I don’t have a Pro License (in the case of Power BI) / also by the large amount of weight of the files, the average is 80 mb per each.

The only solution to improve the time and to store and read them easily I could think would be on a table from SQL Server.

The other issue: these files are created per day, from 01 to 30 of the month, at least from June I have sales until 06/27 but, If I load the entire .CSV file of june, would it cause a duplication of the data? Or will it only include the new data?

The path of my files is:

C:UsersadatamyunitmarketbusinessintelligenceSALES

I have read about the Bulk command, but, I’m not a professional on SQL Server, that’s why I’m requesting your help.

Thanks in advance.

My apologies if I made an error writing this post