Manual Query Keys Didn't Match Row at navigation stage.

[Terence2021]

Running a very straight forward query.

Data shows up fine at the 'Source' step in applied steps.

At the Navigation Step the error pops up.

I'm at a loss since the data appears to be pulling through fine at the source step. I've double checked all the column naming.

[Terence2021 · Accepted solution]

Managed to solve the problem by recreating the query for the table from scratch.  Orginally I had simply altered an already included table imported through the standard methods in power bi.  There must have been some interplay with the original table import that was causing problems.

[otravers]

Not sure what the navigation step is about when the source is already displaying the result of your native query. Navigation step would be useful if you were loading the list of tables/views from the server.