PowerBI connector automated refresh error

[farzaanh]

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.

[Jennifer_Dungan]

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

[TuomasA]

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