Forum Discussion
scheduled refresh COM error: mscorlib, An element with the same key has already been added
- Anonymous5 years ago
Anonymous there is a workaround posted by MS at the bottom of this thread: https://community.powerbi.com/t5/Report-Server/December-2020-Update-Issues-Regarding-Power-BI-Report-Server/td-p/1560294
How to Disable Enhanced Dataset Metadata
Note that Desktop authors can control if the enhanced metadata format is used when editing reports. If you are experiencing the above or similar errors, we recommend disabling the options in desktop as follows:
- Turn off the Enhanced Dataset Metadata option in Power BI Desktop RS
- In Options, under Preview Features, uncheck “Store datasets using enhanced metadata format”
- Restart Power BI Desktop for Report Server
- Restore the old report from the hidden backup in AppData.
- Before the file is upgraded to the new format, a backup copy is saved in the app data folder. For example: C:\Users\myuser\AppData\Local\Microsoft\Power BI Desktop SSRS\TempSaves\Backups.
- Open the backup and you should be able to save the old version of the report back to the server.
The automatic refresh works again for me after restoring the backed-up version.
- Turn off the Enhanced Dataset Metadata option in Power BI Desktop RS
I have the exact same problem. I'm getting this error ever since we upgraded RS to Oct 2020. The refresh worked fine before the update, there are no duplicates etc.
Only workaround now is to refresh on the Desktop (because it still works there) and upload to RS, which is a terrible solution.
So maybe there is a bug in the release?
- Anonymous5 years agoNot applicable
Anonymous yes, as far as I understood this is a bug. We are no the only ones experiencing this issue