Forum Discussion

tomekm's avatar
tomekm
Icon for Helper III rankHelper III
5 years ago
Solved

Error message: "“Expression.Error: The key didn't match any rows in the table"

Hi,

I’m getting this error message when creating a pbi dataflow: “Expression.Error: The key didn't match any rows in the table” (more details below). Please see attached screenshot; error occurs at the “Navigation 1” step.

 

Expression.Error: The key didn't match any rows in the table.

Details

Key = [Item = "REPORT", Kind = "Table"]

Table = #table({"Name", "Data", "Item", "Kind", "Hidden"}, {})

 

Need Help
  • GilbertQ's avatar
    GilbertQ
    5 years ago

    Hi tomekm 

     

    The reason for this error is because it is expecting to find a key from the table called "Data" and there are no keys to match on.

     

    I would make sure that there are valid keys in your table called "Data" that match to your source?

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    5 years ago

    Hi tomekm 

     

    The reason for this error is because it is expecting to find a key from the table called "Data" and there are no keys to match on.

     

    I would make sure that there are valid keys in your table called "Data" that match to your source?

Related content