power bi合并文件出错

海阔天空wyzq

各位大神好：


   通过power query 和 power bi 合并文件时，提示以下截图错误，这个是什么问题啊？怎么解决？
   注：是导入第二个文件夹时出错的，通过自定义列输入公式：=Excel.Workbook([Content],true)时提示错误。

步骤M语言：
let
    源 = Folder.Files("E:\0001财务工作\1004南昌绿高\2004财务\3002收入"),
    删除的列 = Table.RemoveColumns(源,{"Extension", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path"}),
    筛选的行 = Table.SelectRows(删除的列, each ([Name] = "湖北区域绿高-台账2021年.xlsx" or [Name] = "湖北区域绿高-台账2022年.xlsx" or [Name] = "湖北区域绿高-台账2023年.xlsx")),
    已添加自定义 = Table.AddColumn(筛选的行, "自定义", each Excel.Workbook([Content],true)),
    #"展开的“自定义”" = Table.ExpandTableColumn(已添加自定义, "自定义", {"Data"}, {"Data"})
in
    #"展开的“自定义”"


错误全部内容：


意外错误: 值不能为 null。
参数名: key
详细信息:
    Microsoft.Mashup.Evaluator.Interface.ErrorException: 值不能为 null。
参数名: key ---> System.ArgumentNullException: 值不能为 null。
参数名: key ---> System.ArgumentNullException: 值不能为 null。
参数名: key
   在 System.ThrowHelper.ThrowArgumentNullException(ExceptionArgument argument)
   在 System.Collections.Generic.Dictionary`2.FindEntry(TKey key)
   在 Microsoft.Mashup.Engine1.Runtime.Keys.DictionaryStringKeys..ctor(String[] keys)
   在 Microsoft.Mashup.Engine1.Runtime.Keys.New(String[] keys)
   在 Microsoft.Mashup.Engine1.Library.Excel.ExcelReaderOpenXml.CreateTableValue(ExcelWorksheet sheet, String dimension, Boolean useFirstRowAsHeader)
   在 Microsoft.Mashup.Engine1.Library.Excel.ExcelReaderOpenXml.WorksheetTableValueReference.get_Value()
   在 Microsoft.Mashup.Engine1.Runtime.RecordValue.ReferenceArrayRecordValue.get_Item(Int32 index)
   在 Microsoft.Mashup.Engine1.Runtime.RecordValue.TryGetValue(String key, Value& value)
   在 Microsoft.Mashup.Engine1.Runtime.OptionalFieldAccessValueReference.GetValue()
   在 Microsoft.Mashup.Engine1.Runtime.FieldAccessValueReference.get_Value()
   在 Microsoft.Mashup.Engine1.Runtime.RecordValue.ReferenceArrayRecordValue.get_Item(Int32 index)
   在 Microsoft.Mashup.Evaluator.Services.ValueSerializer.<>c__DisplayClass109_0.<WritePreviewFieldValue>b__0()
   在 Microsoft.Mashup.Evaluator.Services.ValueSerializer.HandleErrors(Action action, Action`1 handler)
   在 Microsoft.Mashup.Evaluator.Services.ValueSerializer.<>c__DisplayClass100_2.<WritePreviewTable>b__2()
   在 Microsoft.Mashup.Evaluator.Services.ValueSerializer.HandleErrors(Action action, Action`1 handler)
   在 Microsoft.Mashup.Evaluator.Services.ValueSerializer.<>c__DisplayClass100_1.<WritePreviewTable>b__1()
   在 Microsoft.Mashup.Evaluator.Services.ValueSerializer.HandleErrors(Action action, Action`1 handler)
   在 Microsoft.Mashup.Evaluator.Services.ValueSerializer.HandleErrors(Action action, Action`1 handler)
   在 Microsoft.Mashup.Evaluator.Services.ValueSerializer.WritePreviewTable(IValue value)
   在 Microsoft.Mashup.Evaluator.Services.ValueSerializer.HandleErrors(Action action, Action`1 handler)
   在 Microsoft.Mashup.Evaluator.Services.ValueSerializer.WritePreviewValue(IValue value, Int32 serializeStructuredValueDepth)
   在 Microsoft.Mashup.Evaluator.Services.ValueSerializer.SerializePreviewValue(IEngine engine, IValue value, Action`2 rowCountCallback, Nullable`1 options)
   在 Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count)
   在 Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue()
   在 Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
   在 Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass0_0.<RunStub>b__0()
   在 Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
   --- 内部异常堆栈跟踪的结尾 ---
   在 Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass11_0.<TryReportException>b__1()
   在 Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)
   在 Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)
   在 Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
   在 Microsoft.Mashup.Evaluator.RemotePreviewValueSource.RunStub(IEngineHost engineHost, IMessageChannel channel, Func`1 getPreviewValueSource)
   在 Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass12_1`1.<OnBeginGetResult>b__0()
   在 Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
   在 Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
   在 Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
   在 Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
   在 Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
   在 Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
   在 Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
   在 Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
   在 Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
   在 Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
   在 Microsoft.Mashup.Evaluator.EvaluationHost.Run()
   在 Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)
   在 Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)
   在 Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
   在 Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)
   --- 内部异常堆栈跟踪的结尾 ---
   在 Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
   在 Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
   在 Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
   在 Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
   在 Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
   在 Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
   在 Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
   在 Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
   在 Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
   在 Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

静听溪流

建议数据脱敏后  上传附件