cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Aimeeclaird
Helper IV
Helper IV

Scheduled Refresh - Dataset - Error Message "Key didn't match"

Hi, hoping someone can help.

 

I have recently setup scheduled refresh for a number of datasets however the refreshes appear to be failing - all datasets are connected via Share Point to the same xlsx. file.

 

Yesterday, whilst using my usual business PBI account I got the following error message:

Processing error: The credentials provided for the Share Point source are invalid 

 

Our IT / Microsoft Admin team set up a secondary account for me which they advised had admin rights for PBI.  I went into each dataset as the admin and ensured the credentials were logged in with the admin account, authentication was set to Oauth2 and privacy level to Organisational.

 

However the scheduler has just run and i'm now getting a different error message on them all:

Processing error: The key didn't match any rows in the table.

Cluster URI: WABI-UK-SOUTH-redirect.analysis.windows.net

Activity ID: e3cb7df0-4615-474b-89b4-d6ad47d3bcf0

Request ID: f9bad0d3-21f4-7038-a8f9-d600e5cf5c47

Time: 2021-01-13 13:25:09Z

 

I should add that in both scenarios I have been able to manually refresh the report/dataset from within the pbix. files.

 

Can anyone help with any suggestions or to provide more detail of the admin rights I may need that I can share with our IT support please?

3 REPLIES 3
v-deddai1-msft
Community Support
Community Support

Hi @Aimeeclaird ,

 

Would you please check if you have changed any columns or sheet name in your excel?  If something in your data source is renamed or deleted , it will leads to the issue. For more details, please refer to  https://blog.crossjoin.co.uk/2020/04/06/understanding-the-the-key-didnt-match-any-rows-in-the-table-... and https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table...

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

Hi @v-deddai1-msft Thanks for the reply however this is the first thing I checked as i've seen this error before in Desktop but not Service.

 

After more investigation, it appears that the issue is not only a Scheduled refresh in Service but also manual refreshed in Service too. Everything in Desktop works fine! Very odd. 

 

Thanks,

Aimee

Hi @Aimeeclaird ,

 

Would you please show us the m query in advanced editor of  query editor? There is so little information at the moment that it is difficult to get to the root of the issue.

 

Best Regards,

Dedmon Dai

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors