Error while doing incremental refresh in PBI server

[schanna]

Hi Team,

I am getting the following error message while doing an incremental refresh. Kindlyhelp with the solution.

{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"The key didn't match any rows in the table."}}],"exceptionCulprit":1}}}

[v-luwang-msft · Accepted solution]

Hi @schanna ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @schanna ,

1.Try to check your   the credentials you was using to login.

similar error code case refer:

https://community.powerbi.com/t5/Service/Key-Expression-Error-The-key-didn-t-match-any-rows-in-the-t... 

2. The workaround is to turn off the SameSite settings in the browser. Go to chrome://flags or edge://flags and search for SameSite, disable the 2 (edge) or 3 (chrome) features that show up. Restart and it will work. 

similar error code case refer:

https://community.powerbi.com/t5/Service/The-key-didn-t-match-any-rows-in-the-table/td-p/929654 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[d_gosbell]

You cannot do incremental refreshes on Report Server, only scheduled full refreshes so either you are using the Power BI Service not the on-prem Report Server or your are doing a full refresh.

Either way that looks like it might be an error in your Power Query code. Probably due to something being changed in one of your data sources.

Do you know which table is causing this issue? If and you are doing an incremental refresh can you copy the query for that table into a new file and see if you can refresh passing in the same parameter values that the incremental refresh would be doing. Or if this is actually a full refresh can you open the file in Power BI Desktop and see if it refreshes from there.

You can see issues like this if you are filtering files in a folder, but none of the files match the filter expression. In this case the list of files is stored internally in Power Query in a "table" structure. But many transforms in Power Query can make use of similar "internal" tables.