Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am able to combine multiple .csv files from same folder and create query.
When I attempt this it only imports the first excel file.
And when I list all source file names I get [Expression.Error] The key didn't match any rows in the table.
All excel files have identical headers.
@QQQ,
I have tested it on my local environment, I can combine all the CSV file with out any issue. Could you please provide us more detail steps, so that we can make further analysis.
https://www.youtube.com/watch?v=pMQK1Zcc9jw
Regards,
Charlie Liao
I can also combine all .csv files without issue.
But I am unable to combine all .xlsx files without issue.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |