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 -
Hi,
My datasource is google analytics, I'm getting same error.
From last 2 months query working fine but all of sudden this error pop up.
Anybody have any Idea what can I do.
Thanks in advance.
hi!
i had the same problem and i guess found solution.
if you use two google accounts (gmail) you should have two bi online accounts.
AlexTandem - can you explain a bit in detail about this approach? Right now we have 3 google service accounts for 3 environments/workspace (dev,qa and prod) and I have one power bi developer pro account. we connect to big query data using the google service accounts.
I am also facing scheduled refresh failure in all environments randomly with "Expression.Error: The key did not match any rows in the table".
Every time there is failure I re enter the credentials in service and the scheduled refresh works (this link helped me) fine after that for that day. But the next day the same issue happens and I have to re enter the credentials again.
