Something went wrong error PBIRS (October Release)

[Siva_P]

We are using PBI report server Oct release. Thousands of users access dashboards via SharePoint page. But frequently getting this error.  After researching server logs found these exceptions "Failed to publish model" / "Failure in modelsandexploration".  

 

Here is exception stack trace details. 

Failed to publish model for reportGUID_507223161|

Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to publish model for reportguid_507223161 ---> System.ArgumentException: Item recordID already exists in the collection.
at Microsoft.AnalysisServices.Tabular.NamedMetadataObjectCollection`2.ValidateCanAdd(T item)
at Microsoft.AnalysisServices.Tabular.MetadataObjectCollection`2.Add(T metadataObject)
at Microsoft.AnalysisServices.Tabular.DdlUtil.LoadObjectsFromSchema(DataSet schema, ObjectType[] types, Dictionary`2& objectMap, StringComparerInfo comparerInfo)
at Microsoft.AnalysisServices.Tabular.DdlUtil.LoadModelFromSchema(DataSet schema, ObjectType[] objectTypes, Dictionary`2& objectMap, StringComparerInfo comparerInfo)
at Microsoft.AnalysisServices.Tabular.DdlUtil.DiscoverModel(Database db)
at Microsoft.AnalysisServices.Tabular.Database.LoadModel()
at Microsoft.AnalysisServices.Tabular.Database.get_Model()
at Microsoft.PowerBI.ReportServer.AsServer.TOMWrapper.AddRole(String roleName, String databaseName)
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.<>c__DisplayClass16.<LoadDatabaseInAsAsync>b__15()

--- End of inner exception stack trace ---

Failure in modelsandexploration| Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to publish model for reportGUID_507223161 ---> System.ArgumentException: Item recordID already exists in the collection.
at Microsoft.AnalysisServices.Tabular.NamedMetadataObjectCollection`2.ValidateCanAdd(T item)
at Microsoft.AnalysisServices.Tabular.MetadataObjectCollection`2.Add(T metadataObject)
at Microsoft.AnalysisServices.Tabular.DdlUtil.LoadObjectsFromSchema(DataSet schema, ObjectType[] types, Dictionary`2& objectMap, StringComparerInfo comparerInfo)
at Microsoft.AnalysisServices.Tabular.DdlUtil.LoadModelFromSchema(DataSet schema, ObjectType[] objectTypes, Dictionary`2& objectMap, StringComparerInfo comparerInfo)
at Microsoft.AnalysisServices.Tabular.DdlUtil.DiscoverModel(Database db)
at Microsoft.AnalysisServices.Tabular.Database.LoadModel()
at Microsoft.AnalysisServices.Tabular.Database.get_Model()
at Microsoft.PowerBI.ReportServer.AsServer.TOMWrapper.AddRole(String roleName, String databaseName)
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.<>c__DisplayClass16.<LoadDatabaseInAsAsync>b__15()

Please share any ideas/resolution for this issue? does PBIRS Mar 2018 release has any fix?

[givlehguy]

We are starting to have a similar issue with our dashboards. We have found that pulling them down from the report server and republishing them fixes the issue for a day to a few days. But this is not a fix. We have our server on the latest March 2018 build. Resolution please!