table Dim_IsEagle_Bridge_AIASpecial lineageTag: 89dbfcfb-07fa-4e64-881f-006e993e6e8f column IS_EAGLE_FLAG_CODE dataType: string lineageTag: c3cd36ab-cd38-4c83-9b66-a547708c1355 summarizeBy: none sourceColumn: IS_EAGLE_FLAG_CODE annotation SummarizationSetBy = Automatic partition Dim_IsEagle_Bridge_AIASpecial = m mode: import queryGroup: 非首页 source = ``` let Source = Value.NativeQuery( Databricks.Catalogs( ServerAddress, HttpPath, [ Catalog = CatalogName, Database = null, EnableAutomaticProxyDiscovery = null,EnableQueryResultDownload="0" ] ){ [Name = CatalogName, Kind = "Database"] }[Data], " SELECT CASE WHEN a.data_source = 'AIA(Monthly)' THEN CONCAT(AUDIT_COD, MARKET, DATA_SOURCE) else DATA_SOURCE end AS IS_EAGLE_FLAG_CODE FROM dm.dm_td_external_org A group by 1 " & UsingLimit, null, [ EnableFolding = true ] ), #"Filtered Rows" = Table.SelectRows(Source, each [IS_EAGLE_FLAG_CODE] <> null and [IS_EAGLE_FLAG_CODE] <> "") in #"Filtered Rows" ``` annotation PBI_NavigationStepName = Navigation annotation PBI_ResultType = Table