Forum Discussion

Yousra's avatar
Yousra
Icon for Advocate I rankAdvocate I
8 years ago
Solved

Scheduled refresh failure: An item with the same key - Merged queries

Hello,

 

I've been trying to use the new Scheduled refresh option in Power BI Report Server October 2017.

The refresh fails with the message: "An item with the same key has already been added." when dealing with merged queries. It completes just fine when there is no merge action. 

 

I've tried renaming the columns/tables but it doesn't fix the problem. 

The merge action is very important so I can't delete it. 

 

 

  • The issue seems to be fixed with the March 2018 update!