table Dim_BrandDefaultMKT isHidden lineageTag: 26b52edb-c7e8-4c06-ad2a-4320a22967b9 column BRAND_NAME dataType: string isHidden lineageTag: 4839595c-dc27-4274-9bb9-9e44eb83aee4 summarizeBy: none sourceColumn: BRAND_NAME changedProperty = IsHidden annotation SummarizationSetBy = Automatic column MARKET dataType: string isHidden lineageTag: e6905886-16ef-4d95-a6d8-6e22081dbab9 summarizeBy: none sourceColumn: MARKET changedProperty = IsHidden annotation SummarizationSetBy = Automatic column DATA_SOURCE dataType: string isHidden lineageTag: 5ecb43ae-cd7d-4a5b-b2df-d25ed40fe613 summarizeBy: none sourceColumn: DATA_SOURCE changedProperty = IsHidden annotation SummarizationSetBy = Automatic column MKT_SOURCE = [MARKET] & [DATA_SOURCE] isHidden lineageTag: 894eafdd-30e1-4a26-8de5-01d81bb3283d summarizeBy: none changedProperty = IsHidden annotation SummarizationSetBy = Automatic column VBP dataType: string isHidden lineageTag: c05777c6-1ca6-45cf-9c15-8665d2785d1c summarizeBy: none sourceColumn: VBP changedProperty = IsHidden annotation SummarizationSetBy = Automatic column MKT_FLAG dataType: int64 isHidden formatString: 0 lineageTag: 38b2902d-c7f6-4400-9c6f-2951bc9d87c7 summarizeBy: sum sourceColumn: MKT_FLAG changedProperty = IsHidden annotation SummarizationSetBy = Automatic column PRD_FLAG dataType: int64 isHidden formatString: 0 lineageTag: 162b0e6d-a619-485a-8d3d-b69f9d6a807c summarizeBy: sum sourceColumn: PRD_FLAG changedProperty = IsHidden annotation SummarizationSetBy = Automatic partition Dim_BrandDefaultMKT = 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 BRAND_NAME ,A.MARKET ,A.DATA_SOURCE ,VBP ,INT(B.PRD_FLAG) PRD_FLAG, CASE WHEN A.DATA_SOURCE = 'Retail(Quarterly)' AND A.MARKET IN ( 'Inhaled Extended Market' ,'NIAD (Non-Insulin Anti-Diabetic) Market' ,'Rosuvastatin Market' ,'BUDESONIDE Market' ,'EGFR TKI Market' ,'Anti-HER2 Market' ,'Anti-HER2 mBC Market' ,'Fasenra Market' ,'Severe Asthma') THEN 1 ELSE 0 END MKT_FLAG FROM DM.DM_TD_EXTERNAL_BRAND_MARKET A INNER JOIN DM.DM_TD_EXTERNAL_MARKET B ON A.MARKET = B.MARKET AND A.DATA_SOURCE = B.DATA_SOURCE WHERE A.MARKET IS NOT NULL " & UsingLimit, null, [ EnableFolding = true ] ) in Source ``` changedProperty = IsHidden annotation PBI_ResultType = Exception annotation PBI_NavigationStepName = Navigation