Forum Discussion
kcantor
Community Champion
Community ChampionExpression.Error: The key did not match any rows in the table
I have a data set that has refreshed successfully in the past. It was built 3 days ago and refreshed fine for two days. Now I cannot refresh it either on the desktop version or from services. The err...
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 -
estimados,
Tengo el mismo problema. Estoy trabajando con BigQuery que agrupa muchas sheet de google. Puedo trabajar bien en la version escritorio se actualiza bien, pero al actualizar en la web me genera este error.
Ayuda por favor!
My error still persists, I'm using a source as an import in Google big query, I even separated each table in a pbix file to update, but the error happens in all files, I don't know what to do.