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.
Solved! Go to Solution.
Are you able to refresh the report successfully in the Power BI desktop optimized for report server Oct version?
@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!
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
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 ?