I use the latest version of Power BI Desktop and prepare the table with following definition:
let
Source = AzureStorage.DataLake(Fact_DeltaLake_path, [HierarchicalNavigation=true]),
DeltaTable = DeltaLake.Table(Source),
#"Filtered Rows" = Table.SelectRows(DeltaTable, each [Year] = 2023)
in
#"Filtered Rows"
And after I want to remove some of columns:
let
Source = AzureStorage.DataLake(Fact_DeltaLake_path, [HierarchicalNavigation=true]),
DeltaTable = DeltaLake.Table(Source),
#"Filtered Rows" = Table.SelectRows(DeltaTable, each [Year] = 2023 and [PeriodTypeId] = 1 and [VersionId] = 0 and [Month] = 12 and [DataGroupId] = 4),
#"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"BatchId", "AmountYtd"})
in
#"Removed Columns"
Last step throw the exception:
Error Message:
Index was outside the bounds of the array.
Stack Trace:
Microsoft.Mashup.Host.Document.SerializedException
at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)
Stack Trace Message:
Index was outside the bounds of the array.
Seems like DeltaLake.Table feature have bugs because it rely on column order number - for example, when I remove last one column it works, but deleting of first one throws the same with the samse stack trace.
Maybe I need to implement it in other way for DeltaLake table or there are some workarounds.
