cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
robertsbd Member
Member

Refresh failure: The key didn't match any rows in the table

I have just published a series of reports/dashboards and it appears that there is a problem with the refresh whethre it is the scheduled refresh or whether I do it manually. There are no errors with the desktop files and things will refresh fine there. I am using data sets that have worked fine before. Does anyone have any ideas. Here is the error below.

 

Last refresh failed: Thu Dec 08 2016 10:32:49 GMT+0000 (GMT Standard Time)
Hide details

Data source type: 
Processing error:The key didn't match any rows in the table.
Cluster URI:WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:754541d2-8e3d-4359-90d3-8e8fb15e2b24
Request ID:88cfda59-3dcc-5468-8927-55d8b5554d58
Time:2016-12-08 10:32:49Z

 

4 REPLIES 4
Microsoft v-ljerr-msft
Microsoft

Re: Refresh failure: The key didn't match any rows in the table

Hi @robertsbd,

 

Base on my research, the key not found exception is normally due to an out of sync schema, like the one on the server vs the one cached locally.

 

There're mainly two workarounds for this issue:

 

Solution 1: Click "Refresh Preview" for each query in Query Editor using Power BI Desktop, then save and republish it to Power BI Service.

 

rp.PNG

 

Solution 2: Retype all of the data source credentials in "Dataset Settings" on Power BI Service.

 

cd.PNG

 

Regards

robertsbd Member
Member

Re: Refresh failure: The key didn't match any rows in the table

Hi Thanks for that. I have tried that but am still getting errors. I will attempt to rebuild things a bit more to see if I can flush the errors out. I got rid of them from some other dashboards. The latest one is this. I have set privacy to ignoe privacy levels so not sure why I would be getting this.

 


Last refresh failed: Fri Dec 09 2016 12:40:24 GMT+0000 (GMT Standard Time) 

There was an error when processing the data in the dataset.
Hide details

Data source type: 
Data source error:[Unable to combine data] Section1/ComputerLogons_csv/out is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination.
Cluster URI:WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:628e369a-c3d2-4c72-b3bf-be441454b0f2
Request ID:68351d4a-c420-0d91-d793-c805422bcac6
Time:2016-12-09 12:40:24Z
Microsoft v-ljerr-msft
Microsoft

Re: Refresh failure: The key didn't match any rows in the table

Hi @robertsbd,



I have set privacy to ignoe privacy levels so not sure why I would be getting this.

Have you tried both turning on Fast Combine for your Personal Gateway and enable Fast Combine on Power BI Desktop before republishing your reports?Smiley Happy

 

Regards

robertsbd Member
Member

Re: Refresh failure: The key didn't match any rows in the table

Hi,

 

Thanks I will try this. I suspect the problems I am getting are associated with the Sharepoint problem that is going on at the moment. So I will wait until that has been fixed to see if that fixes my problem.

 

Thanks for your help I will check it out anyway as that looks useful.

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors