Forum Discussion
Solved
Error on Refresh
Hello Folks, I have data files located into sharepoint and I am using web link to connect data for PB dashboard. This is happening second time. I created the dashboard and refresh, it work good ...
That's pretty easy - in this section:
Find "PRIORITY" in red and change it to "DC Week" - just make sure it matches what's shown in the column header in the step earlier
Amjad1002 I'd suggest going into power query and refreshing all of your tables - especially the one that's generating the error. That may fix the issue or it would help track down the error which could be a name change on the table (sheet name change, file name change, something like that).
Here's a good blog about it: https://blog.crossjoin.co.uk/2020/04/06/understanding-the-the-key-didnt-match-any-rows-in-the-table-error-in-power-query-in-power-bi-or-excel/