cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Yousra Advocate I
Advocate I

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 Advocate I
Advocate I

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

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

View solution in original post

14 REPLIES 14
Community Support
Community Support

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 Advocate I
Advocate I

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

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

Power BI Team
Power BI Team

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 Advocate I
Advocate I

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

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

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 Advocate I
Advocate I

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

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

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 ?

 

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.