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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |