Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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.

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

2 Replies

  • otravers's avatar
    otravers
    Community Champion
    4 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.