Forum Discussion
Community ChampionExpression.Error: The key did not match any rows in the table
Ran into this issue myself within the Power BI Desktop and was able to resolve the issue through the following:
- Select Edit Queries from the menu to open the Query Editor
- Use the left hand menu to select one of the queries having the issue (will have the triangular warning sign)
- On the applied steps menu at the right select the source step.
- In the top menu bar, select Refresh Preview.
In my case there were several queries having this same issues and the steps above resolved each of them.
Hope this helps -
AdministratorI have encountered the error "Expression.Error: The key did not match any rows in the table" when importing data from smartsheet to Power BI. The simplest approach would be - you may need to adjust the source key in the query.
a) To do this, go to the 'Advanced Editor' option and find the line that starts with 'Source ='. Replace the existing key with the one that matches your smartsheet data. You can find your data key in the smartsheet URL. For example, if your URL is https://app.smartsheet.com/b/home?lx=2760106596847492, then your data key is '2760106596847492'.
After changing the source key, delete any unnecessary steps (in my case mismatched key step) and click 'Close and Apply' to load your data.
By following these steps, my problem was solved!