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.
Hi everyone, could someone help me out on this please. I imported sharepoint (excel) as data source. It is showing an error:
OLE DB or ODBC error: [Expression.Error] The key didn't match any rows in the table..
Solved! Go to Solution.
See if sheet for Excel file referenced still exists in file.
Proud to be a Super User!
This is a typical case when you connect to an Excel file and then your Query attemps to access a Sheet that does not exist in the Spreadsheet.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
See if sheet for Excel file referenced still exists in file.
Proud to be a Super User!
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |