powerbi - Formula.Firewall：查询（步骤“更改类型”）引用其他查询或步骤

Question

我的查询是从 ADLS Gen 2 blob 读取 CSV 数据到 Azure 表格模型 (Azure AS)。该问题在编辑查询以容纳数据集中的两个新列后开始。原始查询是使用 Visual Studio 向导自动生成的。

问题发生前的步骤：

• Transform File“功能”已更新（列数从 41 增加到 43）
• 主查询已更新为新列元数据（{"RetentionGap", Int32.Type},和{"RetentionGapTo", Int32.Type},）

完整的错误信息：Formula.Firewall: Query 'Fact_VL/Partition' (step 'Changed Type') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

出现问题后，我还尝试使用向导并从“导航”步骤重新构建查询。尽管没有编辑元数据，但仍生成相同的错误（PowerQuery 会将它们弄乱，但希望至少在此时运行基本查询）。请在下面找到完整的查询，让我知道是否有任何与这种情况相关的补救措施。在PowerBI论坛上找到的建议与多个数据源的组合相关，因此在此处仅读取单个数据集时不相关。

let
    Source = #"AzureBlobs/https://fdestorageuat blob core windows net/",
    abidata1 = Source{[Name="abidata"]}[Data],
    #"Filtered Rows" = Table.SelectRows(abidata1, each Text.StartsWith([Name], "OCR/Cubes/OCRDataFoundation/CSV/Fact_VOLSALSL00/Full/PartId=0/")),
    #"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each ([Extension] = ".csv")),
    #"Filtered Hidden Files1" = Table.SelectRows(#"Filtered Rows1", each [Attributes]?[Hidden]? <> true),
    #"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File", each #"Transform File"([Content])),
    #"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}),
    #"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File"}),
    #"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File", Table.ColumnNames(#"Transform File"(#"Sample File"))),
    #"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{
{"SalesDateID", Int32.Type}, 
{"DetailPricingLevelId", Int32.Type}, 
{"LicenseTransactionItemId", Int64.Type}, 
{"ProductID", Int32.Type}, 
{"TopParentProductID", Int32.Type}, 
{"RecordTypeID", Int32.Type}, 
{"SubsidiarySubdistrictId", Int32.Type}, 
{"SubscriptionID", Int64.Type}, 
{"OriginalBillingSalesMonthID", Int32.Type}, 
{"AgreementID", type text}, 
{"ProgramId", Int32.Type}, 
{"BillingCoverageStartDateId", Int32.Type}, 
{"BillingCoverageEndDateId", Int32.Type}, 
{"TermStartDateId", Int32.Type}, 
{"TPID", Int32.Type}, 
{"ActualRevenueAmtCD", type number}, 
{"FromLti", Int64.Type}, 
{"FromProductId", Int32.Type}, 
{"ToLti", Int64.Type}, 
{"ToProductId", Int32.Type}, 
{"CreditLti", Int64.Type}, 
{"OcrCategoryDetailId", Int32.Type}, 
{"OcrCategoryDetailToId", Int32.Type}, 
{"OcrDistance", Int32.Type}, 
{"OcrDistanceTo", Int32.Type}, 
{"ProductUpsellTypeId", Int32.Type}, 
{"WorkloadReplacementFlagId", Int32.Type}, 
{"WorkloadReplacementFlagToId", Int32.Type}, 
{"AllocationFlagId", Int32.Type}, 
{"AllocationFlagToId", Int32.Type}, 
{"IsNewCustomer", type logical}, 
{"IsMidTerm", type logical}, 
{"BCSDAdjusted", Int32.Type}, 
{"BCEDAdjusted", Int32.Type}, 
{"RetentionGap", Int32.Type}, 
{"RetentionGapTo", Int32.Type}, 
{"ActualQuantityCnt", type number}, 
{"ActualLicenseCnt", type number}, 
{"ActualRevenueAmt", type number}, 
{"CommittedLicenseCnt", type number}, 
{"RevenueCommitment", type number}, 
{"BookingEstimateCD", type number}, 
{"BookingEstimate", type number}
})
in
    #"Changed Type"

标签： powerbipowerquery