Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
how can I read list of large csv files in a folder in Excel365? Currently am I using Folder.Files however the "Content" column of Binary data type can't handle large files in a folder (greater than 50-100MB).
Thank you for your help.
harry
Solved! Go to Solution.
Can it read ONE of the files?
>>no
Like if you target a single CSV file, will it discover the meta-data in the file?
>>no
Is there a way to trurn off scanning of the file to do discovery?
>>no in my opinion, but not sure
However I found out, that Folder.Contents does what I need. Weird, both functions have the same structure of output but Folder.Files has problem with large files.
Can it read ONE of the files? Like if you target a single CSV file, will it discover the meta-data in the file? Is there a way to trurn off scanning of the file to do discovery?
Proud to be a Super User! | |
Can it read ONE of the files?
>>no
Like if you target a single CSV file, will it discover the meta-data in the file?
>>no
Is there a way to trurn off scanning of the file to do discovery?
>>no in my opinion, but not sure
However I found out, that Folder.Contents does what I need. Weird, both functions have the same structure of output but Folder.Files has problem with large files.
User | Count |
---|---|
9 | |
8 | |
6 | |
6 | |
6 |