Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Error During Data Refresh

I am receiving the following error wupon refresh of my data,   Expression.Error:  The key didn't match any rows in the table.   Upon closer inspection, when I Go To Error, I am told:   Expressi...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
9 years ago

MarcelBeug

 

Can you further explain your thoughts...not sure what it is that you are suggesting, or how to correct it.

MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

I can not provide specific comments due to lack of informarion from your side.

 

Maybe you can explain in more detail what you are trying to and exactly at which point you get the error?

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    I am simply trying to Refrsh an existing dataset with an updated file.  There are a series of steps I have taken in the Query Editor as well as renaming columns - but like my other work in Power BI I move the updated file, Click Refresh and was expecting the data to update. 

     

    I am wondering if changing the column names or some of the cleanup I am performing in the Query Editor are corrupting the process.

    • MarcelBeug's avatar
      MarcelBeug
      Community Champion
      9 years ago

      Maybe.

       

      Can you share your query code (copy/paste from the advanced editor)?

      • MarcelBeug's avatar
        MarcelBeug
        Community Champion
        9 years ago

        As an example, this is the error I get when importing files from a folder and Book3.xlsx is missing: