The key didn't match any rows in the table

[PaulMartin]

Hi All,

I started getting this error on all of my dashboards at the same time. I am conected to Google BigQuery to supply the data. I am able to go to the desktop app and refresh the data there before re-publishing the report - but this is very time consuming on a daily basis for multiple reports. As far as I can tell, none of the data sources have changed and I have admin access to the data. The details of the error are:

• Data source error{"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}}} Table: KPI_Base_Table.
• Cluster URIWABI-NORTH-EUROPE-D-PRIMARY-redirect.analysis.windows.net
• Activity ID08f58c54-42bf-43e9-b590-9d3c7f9605d3
• Request IDc32491b2-9506-4d88-a6b2-a82cd29fcec0
• Time2020-11-01 00:05:28Z

This has been an issue for weeks now - I tried saving the dashboards as templates then recreated them, but nothing I've tried has helped.

Any help to fix this will be greatly appreciated.

Many thanks,

Paul Martin

[jthomson]

I don't know about Report Server, but I usually get this on Desktop where whatever I'm trying to connect to has seen a name change - normally at my end it's someone changing the name of an Excel worksheet. Might be worth checking something similar?

[PaulMartin]

Thanks for the reply, I really do appreciate it. Unfortunately, I can still refresh from the desktop I just don't seem to be able schedule a refresh. I wish it were a table name change, but then I wouldn't be able to refresh the desktop either.