cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

Expression.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 error reads Expression.Error: The key didn't match any rows int he table. Other tables return the error message Load was cancelled by an error in loading a previous table. I tried to delete the problematic table from the data set with plans to re add it later. When I deleted the problem table, a second table threw the same error. I removed it too and a third then erred.  It is a domino effect. All tables are failing one at a time. The tables, however, are fine. I can use them in other documents and in PowerPivot. any ideas?

A coworker updated her version and the gateway and is getting the same error. This was built in a group and resides in the group folder.

38 REPLIES 38

Good to hear that it helped you to resolve the issue 🙂

Syndicate_Admin
Administrator
Administrator

I had this same issue and in my case it turned out to be permissions on the SQL views. As soon as I added the correct permissions to the views using SQL management studio - BOOM - worked fine.

Yes, I had the same problem and following your suggestion really helped me.

 

Thanks!

Syndicate_Admin
Administrator
Administrator

I had this same issue.  Turns out when I changed some code I was dropping the source table instead of a temp table used in the query.  So, it the source is unavailable it would appear that will also cause this error.

Syndicate_Admin
Administrator
Administrator

Just to add to the growing responses on this error. 

I have resolved this by using Basic Authentication on the Gateway, rather than Windows. This despite desktop using Windows.

 

I'm not fully certain how making this change has worked, given some of my Impala datasources were able to refresh on the Server with Windows, but not others.

 

We re-entered the credentials to the Gateway on Windows authentication and it threw a connection error, upon changing it to Basic it connected and I can now refresh from all Databases the account has access to. 

Hope this helps others. 

Syndicate_Admin
Administrator
Administrator

I have the same problem in Power Query through Excel 2016 too. None of the suggestions in the thread worked for me, unfortunately.

Syndicate_Admin
Administrator
Administrator

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.

Awesome, it worked for, me as well! Thanks a lot😃

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,300)