Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I'm getting the "The key didn't match any row in the table error" after refreshing a new EXCEL file as a data source.
It is not clear why I'm getting this error. I copied and pasted the exact values from one spreadsheet to the main Source spreadsheet that the report was using in the past to include updated information but getting this error.
After selecting the Tranform Data option to see what's up, I see the below error,
In my data source, the name of the field is Start date (with lower case "d" for date).
I getting the error below also which doesn't make sense.
Any help is greatly appreciate it.
Thanks a to!
Solved! Go to Solution.
@kamini ,
Let me know if this helps!
@kamini ,
Let me know if this helps!
@kamini you are using a sheet name called ITD Projects make sure this is the exact name of the sheet in the Excel file, and make sure it is in the same case.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thank you, that solved the problem. I had an extra space after Projects (ITD Projects ")
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
135 | |
112 | |
98 | |
98 | |
92 |