There are pending changes in your queries...

[Sachy123]

Guys, I get this error when I open my power bi model. 

I am not really sure what the freak has changed in the queries!, I also opened the query editor and I see nothing..

When I apply changes, a dimension gets deleted and gets refreshed with all the measures and calculated columns gone!

Please help me !!! I dont have to apply changes and I want to stick to this model.

[mcandell]

I have just installed Power BI desktop on Win10, and at my first try to load data from an excel table I got the message " There are pending changes in your queries...".  I don't understand this error because it is the first time this notebok is running Power Bi Desktop.

I intalled all the Win 10 updates availables, restart the notebook an try again, buy I got the same message.

Please, do you have any idea of what should I do?

Thanks in advance.  Regard.

[mcandell]

When I try to report this error, I got this information:

MESSAGES

Requested value '- 1' was not found.

{"changes":[{"entityCreate":{"properties":[{"property":"ProductoID","sourceColumn":"ProductoID","dataType":"WholeNumber","sourceProviderType":{"MaxLength":null,"Nullable":null,"NumericPrecision":null,"NumericScale":null,"TypeName":null}},{"property":"NombreProducto","sourceColumn":"NombreProducto","dataType":"Text","sourceProviderType":{"MaxLength":null,"Nullable":null,"NumericPrecision":null,"NumericScale":null,"TypeName":null}},{"property":"Idproovedor","sourceColumn":"Idproovedor","dataType":"WholeNumber","sourceProviderType":{"MaxLength":null,"Nullable":null,"NumericPrecision":null,"NumericScale":null,"TypeName":null}},{"property":"Idcategoria","sourceColumn":"Idcategoria","dataType":"WholeNumber","sourceProviderType":{"MaxLength":null,"Nullable":null,"NumericPrecision":null,"NumericScale":null,"TypeName":null}},{"property":"Precio/ud","sourceColumn":"Precio/ud","dataType":"Number","sourceProviderType":{"MaxLength":null,"Nullable":null,"NumericPrecision":null,"NumericScale":null,"TypeName":null}},{"property":"StockUD","sourceColumn":"StockUD","dataType":"WholeNumber","sourceProviderType":{"MaxLength":null,"Nullable":null,"NumericPrecision":null,"NumericScale":null,"TypeName":null}},{"property":"Pedidos","sourceColumn":"Pedidos","dataType":"WholeNumber","sourceProviderType":{"MaxLength":null,"Nullable":null,"NumericPrecision":null,"NumericScale":null,"TypeName":null}},{"property":"Demanda","sourceColumn":"Demanda","dataType":"WholeNumber","sourceProviderType":{"MaxLength":null,"Nullable":null,"NumericPrecision":null,"NumericScale":null,"TypeName":null}}],"dataMode":0,"entity":"Products","mashupExpression":null,"dataSourceName":null,"connectionString":"Provider=Microsoft.PowerBI.OleDb;Global Pipe=9a822b12-8e9e-428c-9965-ae104b9c3483;Mashup=\"UEsDBBQAAgAIACu3i0+bQ8aQqgAAAPoAAAASABwAQ29uZmlnL1BhY2thZ2UueG1sIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAIWPQQ6CMBREr0K657eAoJBPWbiVxIRo3JJaoRGKoUW4mwuP5BU0UYw7dzMvbzHzuN0xm9rGucreqE6nxANGHKlFd1S6SslgT+6KZBy3pTiXlXResjbJZI4pqa29JJSO4whjAF1fUZ8xjx7yTSFq2ZbkK6v/squ0saUWknDcv8dwH5YhhNEihjjykM4Yc6Xn7EEIgR9HwJD+YFwPjR16yaV2dwXSuSL9/OBPUEsDBBQAAgAIACu3i08PyumrpAAAAOkAAAATABwAW0NvbnRlbnRfVHlwZXNdLnhtbCCiGAAooBQAAAAAAAAAAAAAAAAAAAAAAAAAAABtjksOwjAMRK8SeZ+6sEAINWUB3IALRMH9iOajxkXhbCw4ElcgbXeIpWfmeebzelfHZAfxoDH23inYFCUIcsbfetcqmLiRezjW1fUZKIocdVFBxxwOiNF0ZHUsfCCXncaPVnM+xxaDNnfdEm7LcofGOybHkucfUFdnavQ0sLikLK+1GQdxWnNzlQKmxLjI+JewP3kdwtAbzdnEJG2UdiFxGV5/AVBLAwQUAAIACAArt4tPhfKZ1YoBAAAZAwAAEwAcAEZvcm11bGFzL1NlY3Rpb24xLm0gohgAKKAUAAAAAAAAAAAAAAAAAAAAAAAAAAAAbVHBitswFLwH8g9CvTggvCyUHrrkUOJdMIVtaNLuIQ1FsV52TSS9RXoqKSb/Xsmys3QTXYzfvDczzHhoqEXLVvl7ezedTCf+RTpQbOlQhYY8mzMNNJ2w+FYYXANxcn9sQJdP6A47xEPx0GooF2gJLPmCV59/Ddfoy6P2Rz4TzAatBSMXYCYy26jwey13OrFm+m5TE5g5H2EuvrZWzXm/xbenTSVJbgeOD3zxIu1z9Lv++wo8kvRr5dpJ6/fozAJ1MDaBvvhfUHTdqIF1xQWrLX36WKbVk2Adf0SzczBuRJwiwgiO1MO1enWIf0Chu7ytVSMJntG18hJcOmhavAlq5LTB7MD12IqwOfy44mYJqlXoL4EKjLTqncxpzPhLIPwOJvnMSfjbmFHGzrWmR+foHhyan1IHKN6FK9imgr0MmjLVozSptbeitqNqei6rnmmzi8FEQWIYD4Nv+ySRxl2OuW8oxxPjQqeGH916Os1mWae1b3pXe08WfTFYiZKxvHKhQdpIMB5fiejuH1BLAQItABQAAgAIACu3i0+bQ8aQqgAAAPoAAAASAAAAAAAAAAAAAAAAAAAAAABDb25maWcvUGFja2FnZS54bWxQSwECLQAUAAIACAArt4tPD8rpq6QAAADpAAAAEwAAAAAAAAAAAAAAAAD2AAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQItABQAAgAIACu3i0+F8pnVigEAABkDAAATAAAAAAAAAAAAAAAAAOcBAABGb3JtdWxhcy9TZWN0aW9uMS5tUEsFBgAAAAADAAMAwgAAAL4DAAAAAA==\";Location=Products","commandText":"SELECT * FROM [Products]"}},{"setAnnotation":{"topLevelObjectName":"Products","property":null,"levelName":null,"objectType":"Table","annotationName":"PBI_Id","value":"245a5e9d-73f3-4f17-b514-f7d51d3ce0a2"}},{"setAnnotation":{"topLevelObjectName":"Products","property":null,"levelName":null,"objectType":"Table","annotationName":"LinkedQueryName","value":"Products"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"ProductoID","levelName":null,"objectType":"Column","annotationName":"DataTypeAtRefresh","value":"Int64#####not a type"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"ProductoID","levelName":null,"objectType":"Column","annotationName":"PBI_NameAtRefresh","value":"ProductoID"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"NombreProducto","levelName":null,"objectType":"Column","annotationName":"DataTypeAtRefresh","value":"String#####not a type"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"NombreProducto","levelName":null,"objectType":"Column","annotationName":"PBI_NameAtRefresh","value":"NombreProducto"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Idproovedor","levelName":null,"objectType":"Column","annotationName":"DataTypeAtRefresh","value":"Int64#####not a type"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Idproovedor","levelName":null,"objectType":"Column","annotationName":"PBI_NameAtRefresh","value":"Idproovedor"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Idcategoria","levelName":null,"objectType":"Column","annotationName":"DataTypeAtRefresh","value":"Int64#####not a type"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Idcategoria","levelName":null,"objectType":"Column","annotationName":"PBI_NameAtRefresh","value":"Idcategoria"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Precio/ud","levelName":null,"objectType":"Column","annotationName":"DataTypeAtRefresh","value":"Double#####not a type"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Precio/ud","levelName":null,"objectType":"Column","annotationName":"PBI_NameAtRefresh","value":"Precio/ud"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"StockUD","levelName":null,"objectType":"Column","annotationName":"DataTypeAtRefresh","value":"Int64#####not a type"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"StockUD","levelName":null,"objectType":"Column","annotationName":"PBI_NameAtRefresh","value":"StockUD"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Pedidos","levelName":null,"objectType":"Column","annotationName":"DataTypeAtRefresh","value":"Int64#####not a type"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Pedidos","levelName":null,"objectType":"Column","annotationName":"PBI_NameAtRefresh","value":"Pedidos"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Demanda","levelName":null,"objectType":"Column","annotationName":"DataTypeAtRefresh","value":"Int64#####not a type"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Demanda","levelName":null,"objectType":"Column","annotationName":"PBI_NameAtRefresh","value":"Demanda"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"ProductoID","levelName":null,"objectType":"Column","annotationName":"PBI_SortByColumnAtRefresh","value":null}},{"setAnnotation":{"topLevelObjectName":"Products","property":"NombreProducto","levelName":null,"objectType":"Column","annotationName":"PBI_SortByColumnAtRefresh","value":null}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Idproovedor","levelName":null,"objectType":"Column","annotationName":"PBI_SortByColumnAtRefresh","value":null}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Idcategoria","levelName":null,"objectType":"Column","annotationName":"PBI_SortByColumnAtRefresh","value":null}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Precio/ud","levelName":null,"objectType":"Column","annotationName":"PBI_SortByColumnAtRefresh","value":null}},{"setAnnotation":{"topLevelObjectName":"Products","property":"StockUD","levelName":null,"objectType":"Column","annotationName":"PBI_SortByColumnAtRefresh","value":null}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Pedidos","levelName":null,"objectType":"Column","annotationName":"PBI_SortByColumnAtRefresh","value":null}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Demanda","levelName":null,"objectType":"Column","annotationName":"PBI_SortByColumnAtRefresh","value":null}},{"setAnnotation":{"topLevelObjectName":"Products","property":"ProductoID","levelName":null,"objectType":"Column","annotationName":"PBI_WasHiddenAtRefresh","value":"False"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"NombreProducto","levelName":null,"objectType":"Column","annotationName":"PBI_WasHiddenAtRefresh","value":"False"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Idproovedor","levelName":null,"objectType":"Column","annotationName":"PBI_WasHiddenAtRefresh","value":"False"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Idcategoria","levelName":null,"objectType":"Column","annotationName":"PBI_WasHiddenAtRefresh","value":"False"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Precio/ud","levelName":null,"objectType":"Column","annotationName":"PBI_WasHiddenAtRefresh","value":"False"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"StockUD","levelName":null,"objectType":"Column","annotationName":"PBI_WasHiddenAtRefresh","value":"False"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Pedidos","levelName":null,"objectType":"Column","annotationName":"PBI_WasHiddenAtRefresh","value":"False"}},{"setAnnotation":{"topLevelObjectName":"Products","property":"Demanda","levelName":null,"objectType":"Column","annotationName":"PBI_WasHiddenAtRefresh","value":"False"}},{"setAnnotation":{"topLevelObjectName":"Products","property":null,"levelName":null,"objectType":"Table","annotationName":"PBI_DescriptionAtRefresh","value":null}},{"setAnnotation":{"topLevelObjectName":"Products","property":null,"levelName":null,"objectType":"Table","annotationName":"PBI_QueryRelationships","value":"{\"columnCount\":8,\"keyColumnNames\":[],\"queryRelationships\":[],\"columnIdentities\":[\"Section1/Products/Changed Type.{ProductoID,0}\",\"Section1/Products/Changed Type.{NombreProducto,1}\",\"Section1/Products/Changed Type.{Idproovedor,2}\",\"Section1/Products/Changed Type.{Idcategoria,3}\",\"Section1/Products/Changed Type.{Precio/ud,4}\",\"Section1/Products/Changed Type.{StockUD,5}\",\"Section1/Products/Changed Type.{Pedidos,6}\",\"Section1/Products/Changed Type.{Demanda,7}\"],\"ColumnCount\":8,\"KeyColumnNames\":[],\"ColumnIdentities\":[\"Section1/Products/Changed Type.{ProductoID,0}\",\"Section1/Products/Changed Type.{NombreProducto,1}\",\"Section1/Products/Changed Type.{Idproovedor,2}\",\"Section1/Products/Changed Type.{Idcategoria,3}\",\"Section1/Products/Changed Type.{Precio/ud,4}\",\"Section1/Products/Changed Type.{StockUD,5}\",\"Section1/Products/Changed Type.{Pedidos,6}\",\"Section1/Products/Changed Type.{Demanda,7}\"],\"RelationshipInfo\":[]}"}},{"setAnnotation":{"topLevelObjectName":"Products","property":null,"levelName":null,"objectType":"Table","annotationName":"PBI_ResultType","value":"Table"}}],"hasQueryImpact":false}

at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
at System.Environment.get_StackTrace()
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.RunExtendedModelChangeAsync(Action`1 extendedModelChange, CancellationToken cancellationToken, Boolean blockUI)
at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.RunExtendedModelChangeAsync(Action`1 action)
at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.PerformLoadInternal(IPowerBIWindowService windowService, Action relationshipAutodetectStartCallback, ModelChange modelChangeToExecuteBeforeSchemaSync, Boolean skipImpactAnalysisWarning)
at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.<>c__DisplayClass14_0.<PerformLoadAsync>b__0()
at System.Threading.Tasks.Task`1.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
at System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)
at System.Threading.ThreadPoolWorkQueue.Dispatch()

FORMULAS

section Section1;

shared Products = let
Source = Excel.Workbook(File.Contents("D:\Productos.xlsx"), null, true),
Products_Table = Source{[Item="Products",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Products_Table,{{"ProductoID", Int64.Type}, {"NombreProducto", type text}, {"Idproovedor", Int64.Type}, {"Idcategoria", Int64.Type}, {"Precio/ud", type number}, {"StockUD", Int64.Type}, {"Pedidos", Int64.Type}, {"Demanda", Int64.Type}})
in
#"Changed Type";

[mcandell]

Feedback Type:
Frown (Error)

Timestamp:
2019-12-12T05:51:58.5328682Z

Local Time:
2019-12-12T00:51:58.5328682-05:00

Session ID:
6e999a02-f4c0-4f59-b7f4-c90b23ea3b92

Release:
November 2019

Product Version:
2.75.5649.961 (19.11) (x64)

Stack Trace:
at System.Enum.TryParseEnum(Type enumType, String value, Boolean ignoreCase, EnumResult& parseResult)
at System.Enum.Parse(Type enumType, String value, Boolean ignoreCase)
at Microsoft.AnalysisServices.Tabular.RowsetPropertyReader.Microsoft.AnalysisServices.Tabular.IPropertyReader.TryReadProperty[T](String propName, T& propValue)
at Microsoft.AnalysisServices.Tabular.Partition.ReadAllBodyProperties(IPropertyReader reader, Int32 dbCompatibilityLevel)
at Microsoft.AnalysisServices.Tabular.DdlUtil.LoadImpactRow(ObjectType objectType, Int32 dbCompatibilityLevel, RowsetPropertyReader rowsetPropReader, ServerImpact serverImpact, StringComparerInfo comparerInfo)
at Microsoft.AnalysisServices.Tabular.DdlUtil.LoadImpactTable(ObjectType objectType, Int32 dbCompatibilityLevel, DataTable tbl, ServerImpact impact, StringComparerInfo comparerInfo)
at Microsoft.AnalysisServices.Tabular.DdlUtil.LoadImpactFromSchema(DataSet schema, Int32 dbCompatibilityLevel, ServerImpact serverImpact, StringComparerInfo comparerInfo)
at Microsoft.AnalysisServices.Tabular.ImpactDataSet.ConvertToServerImpact(Int32 dbCompatibilityLevel, StringComparerInfo comparerInfo)
at Microsoft.AnalysisServices.Tabular.ExecuteUtil.TryExecuteXmla(String xmlaRequest, Database db, Model model, TxManager txManager, XmlaResultCollection& xmlaResults)
at Microsoft.AnalysisServices.Tabular.Model.SaveChanges(SaveOptions saveOptions)
at Microsoft.PowerBI.Modeler.ModelManager.SaveChanges(String description)
at Microsoft.PowerBI.Modeler.DateTableSubsystem.CreateDateTableTemplate(DateTableDefinition definition)
at Microsoft.PowerBI.Modeler.DateTableSubsystem.SynchronizeLocalDateTables()
at Microsoft.PowerBI.Modeler.DateTableSubsystem.EnableAutomaticLocalDateTables()
at Microsoft.PowerBI.Modeler.DateTableSubsystem.EnableTimeIntelligenceIfNewModel()
at Microsoft.PowerBI.Modeler.DateTableSubsystem.SynchronizeLocalDateTables()
at Microsoft.PowerBI.Modeler.ModelManager.PopulateTableItems(Table table, ModeType modeType, List`1 columns)
at Microsoft.PowerBI.Client.Windows.Modeling.SchemaChangeApplier.Visit(NewTableSchemaChange schemaChange)
at Microsoft.PowerBI.Client.Windows.Modeling.SchemaChangeApplier.Apply(IModelManager modelManager, IEnumerable`1 changes)
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ModelAuthoringTransaction.<>c__DisplayClass13_1.<ExecuteChange>b__0()
at Microsoft.PowerBI.Client.Windows.Modeling.ModelAuthoringExceptionHandler.AddModelChangeResultToExceptions(Action action, ModelChangeResult modelChangeResult)
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ModelAuthoringTransaction.ExecuteChange(ModelChange modelChange, Boolean saveChange)
at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelSchemaSynchronizer.ApplyQuerySchemaToModel(IModelInput modelInput, IExtendedModelChangeScope modelChangeScope, Boolean requireFullDataRefresh)
at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.ApplyQueriesToModel(IAnalysisServicesLoadContext loadContext, IExtendedModelChangeScope modelChangeScope, ModelChange modelChangeToExecuteBeforeSchemaSync, Boolean& runRelationshipDetection, List`1& newTableColumnPairs, HashSet`1& previouslyLoadedInputs)
at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.ProcessLoadInputs(IPowerBIWindowService windowService, IExtendedModelChangeScope modelChangeScope, Action relationshipAutodetectStartCallback, ModelChange modelChangeToExecuteBeforeSchemaSync)
at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.<>c__DisplayClass15_0.<PerformLoadInternal>b__0(IExtendedModelChangeScope modelChangeScope)
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.<>c__DisplayClass16_0.<RunExtendedModelChangeAsync>b__0()
at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.PowerBI.Client.Windows.Utilities.TaskExtensions.WaitAndUnpackException(Task task)
at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.PerformLoadInternal(IPowerBIWindowService windowService, Action relationshipAutodetectStartCallback, ModelChange modelChangeToExecuteBeforeSchemaSync, Boolean skipImpactAnalysisWarning)
at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.<>c__DisplayClass14_0.<PerformLoadAsync>b__0()
at System.Threading.Tasks.Task`1.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.Modeling.LoadToReportFlow.<PerformLoadToAnalysisServices>d__31.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.Modeling.LoadToReportFlow.<Execute>d__23.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.<>c__DisplayClass29_0.<<StartLoadToReportFlow>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.<>c__DisplayClass29_0.<<StartLoadToReportFlow>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()

OS Version:
Microsoft Windows NT 10.0.18363.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 528040]

Peak Virtual Memory:
38.2 GB

Private Memory:
568 MB

Peak Working Set:
911 MB

IE Version:
11.535.18362.0

User ID:
8497365a-a508-48af-a32c-40a711dc5f25

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\mcandell\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot286619802.zip

Model Default Mode:
Empty

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference
PBI_showIncrementalRefreshPolicy
PBI_qnaLiveConnect
PQ_AIInsightsFunctionBrowser
PBI_realTimeRefresh
PBI_userFavoriteResourcePackagesEnabled
PBI_personalVisualizationPaneEnabled
PBI_QueryDiagnostics
PBI_showMinervaRibbon
PBI_showMinervaViewNavigator
PBI_decompositionTree

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
300%

Supported Services:
Power BI

[mcandell]

When I tried to apply the " pending changes" I got this meesage: 

Requested value '- 1' was not found.

[v-yulgu-msft]

Hi @Sachy123,

Such a warning message is prompted when there existing any pending change in Query Editor. We are not able to bypass this messgae. To avoid it, please locate to Query Editor mode, apply and save changes. If you don't want to apply these changes, you may need to check the applied steps one by one in each query and remove those you don't want.

Best regards,

Yuliana Gu