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.
Hello everyone,
So im getting this error after trying to refresh my power bi dashboard, i've read that it maybe because a sheet name was changed in the data source (using Excel in a Sharepoint) but no sheet name was changed. The file was not moved to another location either.
hello , I'm new member of Power BI. Now I'm facing error : Ole db or odbc error the key didn't match any rows in the table power bi. so tell me pls how to fix that one.
Hi, @Anonymous
Generally speaking, it may be due to changes in your table name or column name. You need to check it carefully and make sure there are no leading or trailing spaces in all names.
Reference:Solved: The key didn't match any rows in the table - Microsoft Power BI Community
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Open power query and check for error
debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s
refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs
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 |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |