Important: În Excel pentru Microsoft 365 și Excel 2021, Power View este eliminat începând cu 12 octombrie 2021. Ca alternativă, puteți utiliza experiența vizuală interactivă furnizată de Power BI Desktop, pe care îl puteți descărca gratuit. De asemenea, puteți să importați cu ușurință registre de lucru Excel în Power BI Desktop.
Simptome
Să presupunem că utilizați Power View în Microsoft SharePoint 2013, iar versiunea SQL Server este SQL Server 2012 cu service pack 2 (SP2) sau SQL Server 2014. Atunci când încercați să adăugați mai multe filtre la un raport Power View, primiți următorul mesaj de eroare:
System.ArgumentException: Numele "<Filter Name>" a fost specificat de două ori, la indexul 0 și index 1. Numele dublurilor nu sunt permise.
Nume parametru: chei[1]
la Microsoft.Data.Common.CommandTrees.ExpressionBuilder.Internal.EnumerableValidator'3.Validate(IEnumerable'1 argument, String argumentName, Int32 expectedElementCount, Boolean allowEmpty, Func'3 map, Func'2 collect, Func'3 deduceName)
la Microsoft.Data.Common.CommandTrees.ExpressionBuilder.Internal.EnumerableValidator'3.Validate()
la Microsoft.Data.Common.CommandTrees.ExpressionBuilder.Internal.ArgumentValidation.ValidateGroupBy(DbGroupExpressionBinding input, tastele IEnumerable'1, Agregate IEnumerable'1, DbExpressionList& validKeys, ReadOnlyCollection'1& validAggregates)
la Microsoft.Reporting.QueryDesign.ExpressionTrees.ExpressionBuilder.Internal.QueryExpressionBuilder.GroupBy(QueryGroupExpressionBinding input, IEnumerable'1 groupItems, Agregate IEnumerable'1)
la Microsoft.Reporting.QueryDesign.QueryDefinitionModel.Internal.QdmExpressionBuilder.QdmGroupBy(Expresii IEnumerable'1)
la Microsoft.Reporting.QueryDesign.QueryDefinitionModel.Internal.QdmExpressionBuilder.QdmFilter(Predicatele IGrouping'2)
la System.Linq.Enumerable.WhereSelectEnumerableIterator'2.MoveNext()
la System.Linq.Buffer'1..ctor(IEnumerable'1 source)
la System.Linq.Enumerable.ToArray[TSource](IEnumerable'1 source)
la Microsoft.Reporting.QueryDesign.QueryDefinitionModel.Internal.QdmExpressionBuilder.QdmFilters(IEnumerable'1 filterConditions)
la Microsoft.Reporting.QueryDesign.QueryDefinitionModel.Internal.FilterQueryFactory.AddRowCount(QueryBuilder queryBuilder, Group group, EntitySet entity, IEnumerable'1 rowCountFilterContext)
la Microsoft.Reporting.QueryDesign.QueryDefinitionModel.Internal.FilterQueryFactory.CreateValueWithCountQuery(QueryBuilder queryBuilder, List'1 columns, IEdmFieldInstance fieldInstance, FilterCondition availableValueFilter, FilterCondition activeValueRetentionFilter, GroupReference& groupRef)
la Microsoft.Reporting.QueryDesign.QueryDefinitionModel.Internal.FilterQueryFactory.CreateValueListQuery(Model EntityDataModel, IEdmFieldInstance fieldInstance, Int32 topCount, FilterCondition availableValueFilter, FilterCondition activeValueRetentionFilter, IEnumerable'1 exclusionPathSegments, ValueListQuerySchema& schema)
la Microsoft.Reporting.AdHoc.DataStructureManagement.Filtering.Internal.FilterValueQueryFactory.CreateFilterValuesQuery[TFilterMode](TFilterMode filterMode, Int32 maxRowCount, FormulaFilterCondition availableValueFilter, FormulaFilterCondition activeValueRetentionFilter, ValueListQuerySchema& schema)
la Microsoft.Reporting.AdHoc.DataStructureManagement.Filtering.Internal.ListFilterMode.ListDataLoader.<LoadDataImpl>d__15.MoveNext()
la Microsoft.Reporting.AsyncEnumerator.AsyncEnumeratorBase.MoveNextChecked()
la Microsoft.Reporting.AsyncEnumerator.AsyncEnumeratorBase.ResumeIterator(boolean synchronous)
la Microsoft.Reporting.AsyncEnumerator.AsyncEnumeratorBase.BeginExecuteCore(IEnumerator'1 asyncMethod)
la Microsoft.Reporting.AsyncEnumerator.AsyncEnumeratorImpl.BeginExecute(Func'2 asyncMethod)
la Microsoft.Reporting.AsyncEnumerator.BeginExecute(Func'2 asyncMethod, AsyncCallback userCallback, Object userState, AsyncEnumeratorSettings setări)
la Microsoft.Reporting.AdHoc.DataStructureManagement.Filtering.Internal.FilterMode.DataLoader'1.BeginLoadData(AsyncCallback userCallback, Object userState)
la Microsoft.Reporting.AdHoc.DataStructureManagement.Filtering.Internal.FilterMode.DataLoader'1.LoadDataAsync()
la Microsoft.Reporting.AdHoc.DataStructureManagement.Filtering.Internal.FieldFilter.LoadDataAsyncCore()
la Microsoft.Reporting.AdHoc.DataStructureManagement.Filtering.Internal.FilterManager.OnEditCompleted()
la Microsoft.Reporting.AdHoc.DataStructureManagement.Filtering.Internal.PageFilterManager.OnEditCompleted()
la Microsoft.Reporting.AdHoc.DataStructureManagement.Filtering.Internal.FilterManager.OnEditCompleted(EventArgs args)
la Microsoft.Practices.Prism.Events.EventSubscription'1.InvokeAction(Action'1 action, TPayload argument)
la Microsoft.Practices.Prism.Events.EventSubscription'1.<>c__DisplayClass2.<GetExecutionStrategy>b__0(Object[] argumente)
la Microsoft.Practices.Prism.Events.EventBase.InternalPublish(Object[] argumente)
la Microsoft.Practices.prism.Events.CompositePresentationEvent'1.Publish(TPayload payload)
la Microsoft.Reporting.AdHoc.DataStructureManagement.Internal.TransactionManager.EditEventAggregator.Exit()
la Microsoft.Reporting.AdHoc.DataStructureManagement.Internal.TransactionManager.EditEventAggregator.SelectionManager_SelectionResumed(Expeditor obiect, EventArgs e)
la Microsoft.Reporting.Util.RaiseEvent(EventHandler eventHandler, Object sender, EventArgs eventArgs)
la Microsoft.Reporting.AdHoc.Shell.Regions.Canvas.Internal.SelectionManager.ResumeSelectionChanges()
la Microsoft.Reporting.AdHoc.Shell.Regions.Canvas.Internal.SelectionManager.<.ctor>b__3(Object s, EventArgs e)
la Microsoft.Reporting.Util.RaiseEvent(EventHandler eventHandler, Object sender, EventArgs eventArgs)
la Microsoft.Reporting.AdHoc.DataManagement.Internal.DataManager.set_HandleRdmChanges(valoare booleană)
la Microsoft.Reporting.AdHoc.DataManagement.Internal.DataManager.UndoManager_SuspendRdmHandlingChanged(Expeditor obiect, StateChangedEventArgs'1 args)
la Microsoft.Reporting.Util.RaiseEvent[TEventArgs](EventHandler'1 eventHandler, Object sender, TEventArgs eventArgs)
la Microsoft.Reporting.AdHoc.Shell.Services.UndoManagement.Internal.UndoManager.<.ctor>b__0(Expeditor obiect, StateChangedEventArgs'1 args)
la Microsoft.Reporting.Util.RaiseEvent[TEventArgs](EventHandler'1 eventHandler, Object sender, TEventArgs eventArgs)
la Microsoft.Reporting.AdHoc.Shell.Services.UndoManagement.Internal.UndoManagerApiProperties.set_SuspendDataManagerRdmHandling(valoare booleană)
la Microsoft.Reporting.AdHoc.Shell.Services.UndoManagement.Internal.UndoManagerHasOpenUndoGroupStateImpl.OnUndoGroupCommitting(UndoGroup undoGroup undoGroup)
la Microsoft.Reporting.AdHoc.Shell.Services.UndoManagement.Internal.UndoManagerHasOpenUndoGroupStateImpl.HandleUndoGroupStateChanged(Object sender, EventArgs args)
la Microsoft.Reporting.Util.RaiseEvent(EventHandler eventHandler, Object sender, EventArgs eventArgs)
la Microsoft.Reporting.AdHoc.Shell.Services.UndoManagement.Internal.UndoGroup.HandleStateEnteredEvent(Object sender, EventArgs args)
la Microsoft.Reporting.Util.RaiseEvent(EventHandler eventHandler, Object sender, EventArgs eventArgs)
la Microsoft.Reporting.AdHoc.Shell.Services.UndoManagement.Internal.UndoGroupCommittingStateImpl.EnterState()
la Microsoft.Reporting.AdHoc.Shell.Services.UndoManagement.Internal.UndoGroup.SetState(UndoGroupStateImpl nextState)
la Microsoft.Reporting.AdHoc.Shell.Services.UndoManagement.internal.UndoGroupOpenStateImpl.Commit()
la Microsoft.Reporting.AdHoc.Shell.Services.UndoManagement.internal.UndoGroup.Commit()
la Microsoft.Reporting.AdHoc.DataStructureManagement.Internal.TransactionManager.CompleteTransaction(Transaction transaction, Boolean completedSuccessfully)
la Microsoft.Reporting.AdHoc.DataStructureManagement.internal.TransactionManager.Transaction.Dispose()
la Microsoft.Reporting.AdHoc.DataStructureManagement.Filtering.Internal.ListFilterMode.SelectOnly(rândul ListFilterRow)
la Microsoft.Reporting.AdHoc.Shell.Regions.Canvas.Internal.FilterCheckBoxList.FieldValueSelectorButton_Click(expeditorul obiectului, RoutedEventArgs e)
la System (Sistem). Windows. Controls.Primitivs.ButtonBase.OnClick()
la System (Sistem). Windows. Controls.Button.OnClick()
la System (Sistem). Windows. Controls.Primitivs.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e)
la System (Sistem). Windows. Controls.Control.OnMouseLeftButtonUp(Control ctrl, EventArgs e)
la MS. Internal.JoltHelper.FireEvent(IntPtr unmanagedObj, IntPtr unmanagedObjArgs, Int32 argsTypeIndex, Int32 actualArgsTypeIndex, String eventName, UInt32 flags)
Rezolvare
Această problemă a fost remediată mai întâi în următoarea actualizare cumulativă de SQL Server.
Actualizarea cumulativă 1 SQL Server 2014 SP1 /ro-RO/help/3067839
Actualizarea cumulativă 6 SQL Server 2014 /ro-RO/help/3031047
Actualizarea cumulativă 4 SQL Server 2012 SP2 /ro-RO/help/3007556
Fiecare actualizare cumulativă nouă SQL Server conține toate remedierile rapide și toate remedierile de securitate care au fost incluse cu actualizarea cumulativă anterioară. Consultați cele mai recente actualizări cumulative pentru SQL Server:
Stare
Microsoft a confirmat că aceasta este o problemă în produsele Microsoft enumerate în secțiunea „Se aplică la”.