Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have 3 folders- India ,Germany and US. Each folder contains multiples files.
I have to give the Folder wise total record count.
For eg: India has 3 files - File1 has 5 rows,File2 has 6 rows and File3 has 3 rows, Then Total record count for India would be 14.
Now the Problem is when files are in .xlsx format and using excel.workbook function and then Table.columncount function I get the
counts which works fine.
But when there are .csv files I get the error - DataFormat.Error: External table is not in the expected format.
Let me know how can i do this for .csv files.
Thanks!
Solved! Go to Solution.
Hi @john121 ,
Please try:
Csv.Document([Content])
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @john121 ,
Has your problem been solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.
Best regards,
Yadong Fang
Hi @john121 ,
Has your problem been solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.
Best regards,
Yadong Fang
Hi @john121 ,
Please try:
Csv.Document([Content])
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.