PowerBI connector automated refresh error

Question

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.

TuomasA · Answer

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']").

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded