topic Re: Error: The key didn't match any rows in the table in Report Server

Error: The key didn't match any rows in the table

HugoAARMartins — Fri, 10 Nov 2017 16:51:20 GMT

Hi,

I created some reports in Power BI Desktop, based on Google Analytics data.

Locally everything works fine, but when deployed to Report Server I get the following error either when I try to "refresh now" or in the daily "Schedule History".

Message:	The key didn't match any rows in the table. Table: FACT - New Users.
Cluster URI:	WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:	d316022e-92b2-4302-acfe-1f7334fba5ff
Request ID:	8de96052-9fff-d9d9-29b1-f208d2abee8e
Time:	2017-11-10 15:49:25Z

I'm ready to deploy some reports to our clients, but I can't do it with this error that I cannot understand.

Anyone had this error, specifically with Google Analytics integration?

Thanks for your help,

Best regards,

Hugo

Re: Error: The key didn't match any rows in the table

v-qiuyu-msft — Tue, 14 Nov 2017 01:19:19 GMT

Hi HugoAARMartins,

Can you share the detail steps for us to reproduce the issue? Here is a similar thread which you can have a look, please check if you have merged queries in your dataset.

Best Regards,
Qiuyun Yu

Re: Error: The key didn't match any rows in the table

cashfo01 — Tue, 28 Nov 2017 17:06:11 GMT

I'm having the same problem. Any ideas?

Re: Error: The key didn't match any rows in the table

cashfo01 — Tue, 28 Nov 2017 17:08:22 GMT

I'm having the same problem. Any ideas?

Re: Error: The key didn't match any rows in the table

amanarneja — Tue, 06 Feb 2018 04:52:56 GMT

I am facing the same issue. Not sure what logs or steps to share, I have a seemingly regular dataset with some from SQL (filtered by Date) and some from Excel with mappings between fields as well as New columns and the measures for additional calculations/values.

PowerBI Desktop refreshes just fine, its only in the Service via Scheduled Refresh or Refresh Now that i get the error.

Re: Error: The key didn't match any rows in the table

Mexanism — Wed, 03 Jul 2019 10:19:39 GMT

I have the same problem. Power BI refrshes data in Desktop, but when I try to "refresh now" in PBI Service and while sheduled refresh it comes the error:

Сбой последнего обновления: Wed Jul 03 2019 13:07:29 GMT+0300 (Moscow Standard Time)
Произошла ошибка при обработке данных в наборе данных.Скрыть подробности

Message:	The key didn't match any rows in the table. Table: GA_Str.
URI кластера:	WABI-US-CENTRAL-A-PRIMARY-redirect.analysis.windows.net
Идентификатор действия:	a5d015b2-7d2f-424e-8169-43da9491ab81
Идентификатор запроса:	3204d364-1679-393c-a101-8b7f0b6f2e53
Время:	2019-07-03 10:07:29Z

Any ideas how to solve this?

Re: Error: The key didn't match any rows in the table

amuratova — Mon, 31 May 2021 10:42:46 GMT

Сбой последнего обновления: Mon May 31 2021 14:48:16 (Восточный Казахстан)
Последняя попытка обновления завершилась неудачей из-за внутренней ошибки службы. Обычно это временная проблема. Повторите попытку позже. Если эта проблема возникает снова, обратитесь в службу поддержки.

URI кластера: "WABI-WEST-EUROPE-D-PRIMARY-redirect.analysis.windows.net"

Идентификатор действия: 9b3f63c2-5311-4de6-9811-c085acb47803

Идентификатор запроса: dd4cc931-7fc0-71b0-acb6-d0047e8fe9c9

Время: 2021-05-31 08:48:16Z

перед возникновением проблемы, нами никаких действий не выполнялось. 25.05.2021 данные еще обновлялись, с 26.05.2021 возникла эта ошибка