Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Adobe Analytics refresh error on PowerBI service

Hi,   I have a Power BI report using data from Adobe Analytics. When trying to refresh (manual or schedule) on Power BI Service, it throws the below error: "The key didn't match any rows in the tab...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI Anonymous,

 

It sounds like a general error message who normally appears on cache query table structure not matched with refresh table structure.

 

Have you modify table structure on database side? If this is a case, you need to go to query editor, then double check query table steps to find out unmatched/non-existing/removed fields and fix them.

 

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

Power BI: The key didn’t match any rows in the table

 

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous

 

I am not getting any error while refreshing data in Power BI desktop. It only appears on Power BI Service. 

Also, I am trying to connect to Adobe Analytics (seems like a cube on their end) and don't have visibility on DB side changes.

 

Anything else that I can try out?

 

Thanks

Mansi