Results 1 to 2 of 2

Thread: Expression Error: The key didn't match any rows in the Table
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2005
    Posts
    591
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Expression Error: The key didn't match any rows in the Table

    I was trying to load a couple of files into PowerQuery today and I keep on getting this error message (Expression Error: The key didn't match any rows in the Table).

    Do you know what the possible causes are and how I can fix it.

    I even tried downloading it without making any adjustments and got the same error message.

    Thank you for your help in advance,

    Michael

  2. #2
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,186
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Expression Error: The key didn't match any rows in the Table

    The error means you are trying to do something, but it doesn’t exist. Eg it is trying to import a sheet called “sheet1” but there is no “sheet1” to be found in the table. If you are combining files, check the sheet names in each file. It could be any number of other things too.
    Matt Allington is a professional Power BI Consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia. Matt is author of the Power BI book Supercharge Power BI and the Power Pivot Book Supercharge Excel.
    What is Power BI?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •