Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
kamini
Helper III
Helper III

The key didn't match any row in the table error

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,

kamini_0-1727710585107.png

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.

kamini_1-1727710921382.png

Any help is greatly appreciate it.

Thanks a to!

 

 

1 ACCEPTED SOLUTION
Kedar_Pande
Memorable Member
Memorable Member

@kamini ,

  1. Ensure that "Start date" in Power BI matches exactly as it appears in your Excel sheet, including case.
  2. Check that the Excel table or sheet names referenced in your Power BI query haven't changed. If the table or sheet name changed, update it in Power Query by going to the "Source" step and adjusting the name.

Let me know if this helps!

View solution in original post

3 REPLIES 3
Kedar_Pande
Memorable Member
Memorable Member

@kamini ,

  1. Ensure that "Start date" in Power BI matches exactly as it appears in your Excel sheet, including case.
  2. Check that the Excel table or sheet names referenced in your Power BI query haven't changed. If the table or sheet name changed, update it in Power Query by going to the "Source" step and adjusting the name.

Let me know if this helps!

parry2k
Super User
Super User

@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  ")

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.