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

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. 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Yousra Regular Visitor
Regular Visitor

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

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

14 REPLIES 14
Moderator v-qiuyu-msft
Moderator

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

Hi @Yousra,

 

Are you able to refresh the report successfully in the Power BI desktop optimized for report server Oct version? 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yousra Regular Visitor
Regular Visitor

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

Yes, the report can be refreshed using Power BI Desktop.

Moderator mgmeyer
Moderator

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

@Yousra thanks for reporting this issue and it is something we are looking in to. Do you have an isolated repro that you can private mesage me to help us reproduce this on our end? Thanks!

Yousra Regular Visitor
Regular Visitor

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

Hello @mgmeyer, I've sent you a private message including an example that reproduces the error.

Thank you!

shariq Frequent Visitor
Frequent Visitor

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

Hi,

 

I have the same issue when i try merge action. Do you know some solution of this problem ?

IGray Frequent Visitor
Frequent Visitor

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

Same problem here, the report refreshes fine in desktop, but not on the report server, if I cut out the merge it works fine, but then the report is not complete

 

Update I did some further testing and for me it seems to be when i use a SQL statement as the source and merge, if I dump the data into tables on a SQL server and use these for the merge, it refreshes on the server

Yousra Regular Visitor
Regular Visitor

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

Thanks @IGray for your suggestion.

Tried importing the data as a table instead of an sql query, then merging and the data refresh works!

IGray Frequent Visitor
Frequent Visitor

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

I have also discoverd you can use sql views to get around this problem

M_Lechner Frequent Visitor
Frequent Visitor

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

I have the same Problem and i can't fix it...

I use the October 2017 Update 2.51.4885.1423 (x64).

I can refresh it in Power BI Desktop but not scheduled on the Reporting Service

Has anyone a solution for this ?