Forum Discussion
Microsoft EmployeePower BI Report Server October 2020 update has been released.
Hi,
We have been using a specific dashboard for over a year and everything worked just fine. However, now After installing Power BI October 2020 version and when we have got the latest updated version we are getting the below error:
SessionID: 6e1991ba-35e2-4372-95eb-e2eb0a2f5d84
[0] -1056505856: COM error: mscorlib, An item with the same key has already been added..
[1] -1055784828: The database operation was cancelled because of an earlier failure.
Report data sources are mainly SQL databases and Excel Files. We have also done some Merges and Appends. I have used the remove duplicated rows in Query(even that there are no duplicated rows) and renamed columns that have the same name, but nothing works. Also, I have tried this https://community.powerbi.com/t5/Report-Server/Power-BI-Report-Server-October-2020-update-has-been-released/m-p/1506447/highlight/true#M16820 and disable the Feature'' Store datasets enhanced metadata format''. unfortunately, nothing worked.
The dashboard is very important to us and was working perfectly. Could you please provide me with a solution?
Thank you for your time and consideration in regard to this matter,
I look forward to hearing from you very soon,
Best Regards,
Hi,
I had face a similar issue. It seemed to me that somehow Power Bi was detecting that there was a duplicate of the same report, as I had downloaded the report and tried to save it in a different location by renaming it, but it won't allow me. I made a fresh copy of the report by making transformations in the Query Editor/Transform Data, and copied the visuals- Later when saved it in RS, it didn't show up that error.
Was troublesome to go through scratch again, but that was the quickest solution I got to get the dashboard running back in corporate environment.