table Dim_RC_Merged_Data lineageTag: 96000f39-4333-4de0-aadd-89d481bc13a3 column KEY dataType: string lineageTag: ef40fbb2-e0cc-4dc2-bd87-b89ec8e48f89 summarizeBy: none sourceColumn: KEY annotation SummarizationSetBy = Automatic column MARKET dataType: string lineageTag: 57d6ffb7-f7e5-4024-aee3-a4905383f349 summarizeBy: none sourceColumn: MARKET annotation SummarizationSetBy = Automatic column IS_TARGET_HP dataType: string lineageTag: 98f47592-994c-4290-98f3-1a406bd5edbb summarizeBy: none sourceColumn: IS_TARGET_HP annotation SummarizationSetBy = Automatic partition Dim_RC_Merged_Data = 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 distinct concat( AUDIT_COD ,DATA_SOURCE ) KEY ,MARKET ,CASE WHEN (A.REGION_CODE ='ROC' OR A.REGION_CODE ='' OR A.REGION_CODE IS NULL ) AND A.DATA_SOURCE = 'AIA(Monthly)' THEN 'N' ELSE 'Y' END AS IS_TARGET_HP from DM.dm_td_external_org_merged_data A " & UsingLimit, null, [ EnableFolding = true ] ) in Source ``` annotation PBI_NavigationStepName = Navigation annotation PBI_ResultType = Table