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

The issue is:
I have sales files on 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, but, I cannot do a Incremental Refresh because I don’t have a Pro Licence (in the case of Power BI) / also by the large ammount 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.

The other issue:
This 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 only be 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, that’s why I’m requesting your help.

thanks in advance.
My appologiece if I make an error writing this post