Scheduled refresh error - Item: (here is User ID) already exists in the collection

[Anonymous]

Hello!

During scheduled refresh on Bi server following error occured:

Item: '(here is user ID f.e. xxNET/17361379' already exists in the collection.

Can someone explain me why it occured?

Thank you!

[shiboli]

Hello, 

We have identified the problem. It's a race condition. A proper fix will be included in upcoming Janauary release. Until then, please use some workaround like:

- Schedule your refresh at a time when the server is least used;

- Restart PBIRS instance. 

[givlehguy]

Is this issue confirmed as fixed in the January release? We are still getting the issue and we are using the August release, so if we know for sure that it was addressed we will go ahead and upgrade. 

[Anonymous]

I scheduled refresh at time when noone opens dashboard, since then I do not have this issue, but it seems like work around or coincidence - not a solution

[harikishant]

The error usually occurs when there are duplicate columns in your data set. Can you please check and confirm?

Cheers,

Hari T

[power_bi_1]

I am getting the same error as well. Does not appear to be related to the columns in the dataset though, seems like something to do with the user account. Below is the full stacktrace and it affects all scheduled refreshes (refresh of the same report from PowerBI Desktop and uploading works fine). 

Error Failed Data Refresh, Exception Microsoft.PowerBI.ReportServer.AsServer.Exceptions.TOMClientServerRefreshException: Refresh on Analysis Services Server failed with exception: {0} ---> System.ArgumentException: Item 'domain\username' 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.ModelRoleMember.ResolveLinks(Dictionary`2 objectMap, Boolean throwIfCantResolve)
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.OnAfterRefresh(Boolean full, Nullable`1 refreshType)
at Microsoft.AnalysisServices.Tabular.Server.OnAfterRefresh(Boolean full, Nullable`1 refreshType)
at Microsoft.AnalysisServices.MajorObject.Refresh(Boolean full)
at Microsoft.PowerBI.ReportServer.AsServer.TOMWrapper.Refresh(Boolean full)

[power_bi_1]

This was consistently failing until a restart of the Power BI Report Service on the report server fixed the issue. Worth a try if you run into this issue. 

[Anonymous]

Does anybody solve this problem?

[JonasKjeldsenDK]

We have the same issue:

2018-11-21 09:31:10.1560|ERROR|10|Error Processing Data Model Refresh: SessionId: cc788693-64b0-44be-b871-ec79a9ef93cc, Status: Error Failed Streaming model to Analysis Server, Exception System.AggregateException: One or more errors occurred. ---> Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to publish model for 900de0de-06e4-402d-9840-9cab583e2615_10735179 ---> System.ArgumentException: Item 'DOMAIN\USER' already exists in the collection.

What does it mean?

We are on August version of PBIRS on prem.