cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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 table.. The exception was raised by the IDbCommand interface. Table: Trends."

 

Interestingly, 

  • every time I try refreshing on Power BI Service, it throws the same error but for a different table.
  • getting this error for both Manual and scheduled refresh
  • Refresh is working correctly (with no error) on Power BI Desktop.

 

image.png

 

Has anyone faced it? Any recommended solutions?

 

Thanks in advance

Mansi

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Adobe Analytics refresh error on PowerBI service

HI @mansi,

 

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

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Adobe Analytics refresh error on PowerBI service

Hi @v-shex-msft

 

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

Highlighted
Community Support
Community Support

Re: Adobe Analytics refresh error on PowerBI service

Hi @mansi,

 

Is there any advanced operations in you query table?(e.g. append, merge, refer other query, invoke custom function...) 

 

In addition, you can also submit a support ticket for this issue, it is free for pro users.

submit a support ticketsubmit a support ticket

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Adobe Analytics refresh error on PowerBI service

Hi @v-shex-msft

 

Yes, I had one query with Append. I tried removing that query, but it still doesn't work.

 

Rest all the queries have a simple filter and a custom column added. 

 

I have a ticket open with the support team.

 

Thanks

Mansi

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors