COM error: mscorlib, Index was out of range

[Anonymous]

COM error: mscorlib, Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index. The database operation was cancelled because of an earlier failure. 

So today, all of my reports failed to scheudle refresh eventhough they come from different data sources, has anyone seen this eroor before. Is this somehting that i am able to control or is this an issue with Power Bi online?

[Anonymous]

I am having the same issue as of yesterday.  I tried on both the newest gateway and a gateway from months ago.  The PBIX file refreshes fine in desktop but not in web.

COM error: mscorlib, Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index. The command has been canceled.. The exception was raised by the IDbCommand interface. The database operation was cancelled because of an earlier failure. The command has been canceled.. The exception was raised by the IDbCommand interface. COM error: mscorlib, Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index. Table: Invoices MTD YTD.

[Anonymous · Accepted solution]

Microsoft is fixing the bug but it will take two weeks.  If you are having the problems still here is their work around.

First disable the preview feature "Store datasets using enhanced metadata format"

Use the below location to get the backup file for original (pre-update) format or before the enhanced metadata was disabled. C:\Users\\AppData\Local\Microsoft\Power BI Desktop\TempSaves\Backup. If using the Microsoft Store version of Power BI Desktop, use the following location: C:\Users\\Microsoft\Power BI Desktop Store App\TempSaves\Backups Copy the file to a location you would prefer, in order to preserve it. Make sure the enhanced metadata format preview feature is disabled in Power BI Desktop if you choose to open or use that original file.

[amitchandak]

@Anonymous , open transform data mode and check for any error. and try to resolve that.

refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s

if not able to find then log an issue - https://community.powerbi.com/t5/Issues/idb-p/Issues

[Greg_Deckler]

@Anonymous - Probably an issue with the Service. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".