table Dim_IsEagle_AIASpecial lineageTag: c34d37c1-0fa9-4028-b722-cc5f40d5a0c6 column IS_EAGLE_FLAG_CODE dataType: string lineageTag: 44dd3005-dc3e-411d-94a5-1a80078caceb summarizeBy: none sourceColumn: IS_EAGLE_FLAG_CODE annotation SummarizationSetBy = Automatic column is_eagle dataType: string lineageTag: 4ba13d1a-aae9-442f-b89e-ee8cd2e07faa summarizeBy: none sourceColumn: is_eagle annotation SummarizationSetBy = Automatic partition Dim_IsEagle_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 CONCAT(AUDIT_COD, MARKET, DATA_SOURCE) AS IS_EAGLE_FLAG_CODE, CASE when MARKET = 'AIA ALL Market' and DATA_SOURCE = 'AIA(Monthly)' then ' ' --AIA ALL Market 不用挂eagle flag WHEN is_eagle IN ('雾针等级医院','消化口服医院') THEN is_eagle else ' ' END AS is_eagle --is_eagle FROM dm.dm_td_aia_is_eagle_flag group by 1,2 " & UsingLimit, null, [ EnableFolding = true ] ) in Source ``` annotation PBI_NavigationStepName = Navigation annotation PBI_ResultType = Table