topic Re: Error while doing incremental refresh in PBI server in Report Server

Error while doing incremental refresh in PBI server

schanna — Fri, 25 Feb 2022 07:24:11 GMT

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

Re: Error while doing incremental refresh in PBI server

d_gosbell — Sat, 26 Feb 2022 03:50:27 GMT

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.

Re: Error while doing incremental refresh in PBI server

v-luwang-msft — Tue, 01 Mar 2022 08:22:03 GMT

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-table/td-p/50899

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

Re: Error while doing incremental refresh in PBI server

v-luwang-msft — Fri, 04 Mar 2022 09:09:45 GMT

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