The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello everyone,
I have recently discovered the ability to set the datasource to a sharepoint folder and combine the .csv files in said folder. This has been very helpful but in planning ahead I am trying to find out if there is a limitation to this in terms of the number of .csv files that can be combined. I know that this could be dependant on the size of the tables in the files but if theres any way to get an estimation of this size that would be helpful. Also this is based on all the files having the same columns in them.
Solved! Go to Solution.
Hi @Ctheodo5
there is no official limit for number of files and I do not believe you will able to reach it if it exists 🙂
anyway, there is also a limit for dataset size that depends on your license