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

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
Microsoft
Microsoft

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
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors