Važno: U programu Excel za Microsoft 365 i Excel 2021, Power View se uklanja 12. oktobra 2021. Kao alternativu, možete da koristite interaktivno vizuelno iskustvo koje pruža Power BI Desktop,koje možete besplatno da preuzmete. Takođe možete lakouvesti Excel radne sveske u Power BI Desktop.
Simptomi
Pretpostavimo da koristite Power View u programu Microsoft SharePoint 2013, SQL Server verzija je SQL Server 2012 servisni paket 2 (SP2) ili SQL Server 2014. Kada pokušate da dodate više filtera u Power View izveštaj, dobijate sledeću poruku o grešci:
System.ArgumentException: Ime "<Ime filtera>" je dvaput navedeno, u indeksu 0 i indeksu 1. Duplirana imena nisu dozvoljena.
Ime parametra: tasteri[1] at 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 deriveName) na lokaciji Microsoft.Data.Common.CommandTrees.ExpressionBuilder.Internal.EnumerableValidator'3.Validate() na lokaciji Microsoft.Data.Common.CommandTrees.ExpressionBuilder.Internal.ArgumentValidation.ValidateGroupBy(DbGroupExpressionBinding input, IEnumerable'1 tasteri, IEnumerable'1 agregates, DbExpressionList& validKeys, ReadOnlyCollection'1& validAggregates) na lokaciji Microsoft.Reporting.QueryDesign.ExpressionTrees.ExpressionBuilder.Internal.QueryExpressionBuilder.GroupBy(QueryGroupExpressionBinding input, IEnumerable'1 groupItems, IEnumerable'1 agregates) na lokaciji Microsoft.Reporting.QueryDesign.QueryDefinitionModel.Internal.QdmExpressionBuilder.QdmGroupBy(IEnumerable'1 izrazi) na lokaciji Microsoft.Reporting.QueryDesign.QueryDefinitionModel.Internal.QdmExpressionBuilder.QdmFilter(IGrouping'2 predikati) at System.Linq.Enumerable.WhereSelectEnumerableIterator'2.MoveNext() at System.Linq.Buffer'1..ctor(IEnumerable'1 source) at System.Linq.Enumerable.ToArray[TSource](IEnumerable'1 source) na lokaciji Microsoft.Reporting.QueryDesign.QueryDefinitionModel.Internal.QdmExpressionBuilder.QdmFilters(IEnumerable'1 filterConditions) na lokaciji Microsoft.Reporting.QueryDesign.QueryDefinitionModel.Internal.FilterQueryFactory.AddRowCount(QueryBuilder upitBuilder, grupa, EntitySet entity, IEnumerable'1 rowCountFilterContext) na lokaciji Microsoft.Reporting.QueryDesign.QueryDefinitionModel.Internal.FilterQueryFactory.CreateValueWithCountQuery(QueryBuilder queryBuilder, List'1 kolone, IEdmFieldInstance poljeInstance, FilterCondition availableValueFilter, FilterCondition activeValueRetentionFilter, GroupReference& groupRef) na lokaciji Microsoft.Reporting.QueryDesign.QueryDefinitionModel.Internal.FilterQueryFactory.CreateValueListQuery(EntityDataModel model, IEdmFieldInstance poljeInstance, Int32 topCount, FilterCondition availableValueFilter, FilterCondition activeValueRetentionFilter, IEnumerable'1 exclusionPathSegments, ValueListQuerySchema& šema) na lokaciji Microsoft.Reporting.AdHoc.DataStructureManagement.Filtering.Internal.FilterValueQueryFactory.CreateFilterValuesQuery[TFilterMode](TFilterMode filterMode, Int32 maxRowCount, FormulaFilterCondition availableValueFilter, FormulaFilterCondition activeValueRetentionFilter, ValueListQuerySchema& šema) na lokaciji Microsoft.Reporting.AdHoc.DataStructureManagement.Filtering.Internal.ListFilterMode.ListDataLoader.<LoadDataImpl>d__15.MoveNext() na lokaciji Microsoft.Reporting.AsyncNumerator.AsyncNumeratorBase.MoveNextChecked() na lokaciji Microsoft.Reporting.AsyncNumerator.AsyncNumeratorBase.ResumeIterator(Bulova sinhronizacija) na lokaciji Microsoft.Reporting.AsyncNumerator.AsyncEnumeratorBase.BeginExecuteCore(INumerator'1 asyncMethod) na lokaciji Microsoft.Reporting.AsyncNumerator.AsyncEnumeratorImpl.BeginExecute(Func'2 asyncMethod) at Microsoft.Reporting.AsyncNumerator.BeginExecute(Func'2 asyncMethod, AsyncCallback userCallback, Object userState, AsyncNumeratorSettings settings) na lokaciji Microsoft.Reporting.AdHoc.DataStructureManagement.Filtering.Internal.FilterMode.DataLoader'1.BeginLoadData(AsyncCallback userCallback, Object userState) na lokaciji Microsoft.Reporting.AdHoc.DataStructureManagement.Filtering.Internal.FilterMode.DataLoader'1.LoadDataAsync() na lokaciji Microsoft.Reporting.AdHoc.DataStructureManagement.Filtering.Internal.FieldFilter.LoadDataAsyncCore() na lokaciji Microsoft.Reporting.AdHoc.DataStructureManagement.Filtering.Internal.FilterManager.OnEditCompleted() na lokaciji Microsoft.Reporting.AdHoc.DataStructureManagement.Filtering.Internal.PageFilterManager.OnEditCompleted() na lokaciji Microsoft.Reporting.AdHoc.DataStructureManagement.Filtering.Internal.FilterManager.OnEditCompleted(EventArgs args) u delu Microsoft.Practices.Prism.Events.EventSubscription'1.InvokeAction(Action'1 action, TPayload argument) na lokaciji Microsoft.Practices.Prism.Events.EventSubscription'1.<>c__DisplayClass2.<GetExecutionStrategy>b__0(Object[] argumenti) u članku Microsoft.Practices.Prism.Events.EventBase.InternalPublish(Object[] argumenti) na lokaciji Microsoft.Practices.Prism.Events.CompositePresentationEvent'1.Publish(TPayload payload) na lokaciji Microsoft.Reporting.AdHoc.DataStructureManagement.Internal.TransactionManager.EditEventAggregator.Exit() at Microsoft.Reporting.AdHoc.DataStructureManagement.Internal.TransactionManager.EditEventAggregator.SelectionManager_SelectionResumed(Object sender, EventArgs e) at Microsoft.Reporting.Util.RaiseEvent(EventHandler eventHandler, Object sender, EventArgs eventArgs) na lokaciji Microsoft.Reporting.AdHoc.Shell.Regions.Canvas.Internal.SelectionManager.ResumeSelectionChanges() na lokaciji Microsoft.Reporting.AdHoc.Shell.Regions.Canvas.Internal.SelectionManager.<.ctor>b__3(object s, EventArgs e) at Microsoft.Reporting.Util.RaiseEvent(EventHandler eventHandler, Object sender, EventArgs eventArgs) at Microsoft.Reporting.AdHoc.DataManagement.Internal.DataManager.set_HandleRdmChanges(Bulva vrednost) at Microsoft.Reporting.AdHoc.DataManagement.Internal.DataManager.UndoManager_SuspendRdmHandlingChanged(Object sender, StateChangedEventArgs'1 args) na lokaciji Microsoft.Reporting.Util.RaiseEvent[TEventArgs](EventHandler'1 eventHandler, Object sender, TEventArgs eventArgs) at Microsoft.Reporting.AdHoc.Shell.Services.UndoManagement.Internal.UndoManager.<.ctor>b__0(Object sender, StateChangedEventArgs'1 args) na lokaciji Microsoft.Reporting.Util.RaiseEvent[TEventArgs](EventHandler'1 eventHandler, Object sender, TEventArgs eventArgs) at Microsoft.Reporting.AdHoc.Shell.Services.UndoManagement.Internal.UndoManagerApiProperties.set_SuspendDataManagerRdmHandling(Bulva vrednost) na lokaciji Microsoft.Reporting.AdHoc.Shell.Services.UndoManagement.Internal.UndoManagerHasOpenUndoGroupStateImpl.OnUndoGroupCommitting(UndoGroup undoGroup) na lokaciji Microsoft.Reporting.AdHoc.Shell.Services.UndoManagement.Internal.UndoManagerHasOpenUndoGroupStateImpl.HandleUndoGroupStateChanged(Object sender, EventArgs args) at Microsoft.Reporting.Util.RaiseEvent(EventHandler eventHandler, Object sender, EventArgs eventArgs) na lokaciji Microsoft.Reporting.AdHoc.Shell.Services.UndoManagement.Internal.UndoGroup.HandleStateEnteredEvent(pošiljalac objekta, EventArgs args) at Microsoft.Reporting.Util.RaiseEvent(EventHandler eventHandler, Object sender, EventArgs eventArgs) na lokaciji Microsoft.Reporting.AdHoc.Shell.Services.UndoManagement.Internal.UndoGroupCommittingStateImpl.EnterState() na lokaciji Microsoft.Reporting.AdHoc.Shell.Services.UndoManagement.Internal.UndoGroup.SetState(UndoGroupStateImpl nextState) na lokaciji Microsoft.Reporting.AdHoc.Shell.Services.UndoManagement.Internal.UndoGroupOpenStateImpl.Commit() na lokaciji Microsoft.Reporting.AdHoc.Shell.Services.UndoManagement.Internal.UndoGroup.Commit() na lokaciji Microsoft.Reporting.AdHoc.DataStructureManagement.Internal.TransactionManager.CompleteTransaction(Transaction transaction, Boolean completedSuccessfully) na lokaciji Microsoft.Reporting.AdHoc.DataStructureManagement.Internal.TransactionManager.Transaction.Dispose() na lokaciji Microsoft.Reporting.AdHoc.DataStructureManagement.Filtering.Internal.ListFilterMode.SelectOnly(RedFilterRow) at Microsoft.Reporting.AdHoc.Shell.Regions.Canvas.Internal.FilterCheckBoxList.FieldValueSelectorButton_Click(Object sender, RoutedEventArgs e) u čijoj su sistemu. Windows. Controls.Primitives.ButtonBase.OnClick() u čijoj su sistemu. Windows. Controls.Button.OnClick() u čijoj su sistemu. Windows. Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e) u čijoj su sistemu. Windows. Controls.Control.OnMouseLeftButtonUp(Control ctrl, EventArgs e) u MS. Internal.JoltHelper.FireEvent(IntPtr unmanagedObj, IntPtr unmanagedObjArgs, Int32 argsTypeIndex, Int32 actualArgsTypeIndex, String eventName, UInt32 flags)Rezolucija
Ovaj problem je prvi put rešen u sledećoj kumulativnoj ispravki sistema SQL Server.
Kumulativna ispravka 1 za SQL Server 2014 SP1 /help/3067839
Kumulativna ispravka 6 SQL Server 2014/help/3031047
Kumulativna ispravka 4 za SQL Server 2012 SP2 /help/3007556
Svaka nova kumulativna ispravka za SQL Server sadrži sve hitne ispravke i sve bezbednosne ispravke koje su uključene u prethodnu kumulativnu ispravku. Pogledajte najnovije kumulativne ispravke za SQL Server:
Status
Microsoft je potvrdio da je u tome problem u Microsoft proizvodima koji su navedeni u odeljku "Odnosi se na".