PowerBI connector automated refresh error | Community
Skip to main content
F
farzaanh
Level 2
October 7, 2024
Question

PowerBI connector automated refresh error

  • October 7, 2024
  • 2 replies
  • 771 views

Hi, I've built a dashboard in PowerBI using Adobe Analytics data via the 2.0 connector. I'm able to refresh and publish my dashboard from PBI Desktop to PBI Web, but when setting up automated refreshing in PBI web, I encounter the following error when it attempts to refresh:

<ccon>Expression.Error: The key didn't match any rows in the table.. Key = [Id = "cm300000167_66f447fe9b0e4356d07ab153"]. Table = #table({"Id", "Name", "Description", "Kind", "Data"}, {}). </ccon>;<ccon>The key didn't match any rows in the table.</ccon>. The exception was raised by the IDbCommand interface. Table: Adobe_Table.

 

I understand that PBI Web is looking for a key that doesn't match what it finds in the table, but I'm confused as I've had no issue with it in PBI desktop, so not sure what to fix.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
October 7, 2024

This might require Client Care to look deeper into the issue... Good Luck!

T
TuomasA
December 4, 2024

Did you manage to resolve this issue?

We’re experiencing exactly the same problem, and it seems to be related to custom metrics.


We can update the data when using page and page views, but when we include custom metrics, the update fails.


I noticed that you're also using custom metrics (Error: "The key didn't match any rows in the table.. Key = [Id = 'cm300000167_66f447fe9b0e4356d07ab153']").

Terms & ConditionsAccessibility statement

Loading footer...