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

[tomekm]

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"}, {})

[GilbertQ · Accepted solution]

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?