table AIA_AdvanceAnalysis_Class lineageTag: 96f2b1bb-b518-43bd-9ce9-d624f66445ef column CLASS dataType: string lineageTag: b791d2e3-9a62-4dac-95d0-239820e8586b summarizeBy: none sourceColumn: CLASS sortByColumn: RANK changedProperty = SortByColumn annotation SummarizationSetBy = Automatic column RANK dataType: int64 formatString: 0 lineageTag: 0699056d-44e0-4aa3-bcd4-b05abf1205f2 summarizeBy: none sourceColumn: RANK annotation SummarizationSetBy = Automatic partition AIA_AdvanceAnalysis_Class = m mode: import queryGroup: 'AIA 独有表' source = ``` let Source = Value.NativeQuery( Databricks.Catalogs( ServerAddress, HttpPath, [ Catalog = CatalogName, Database = null, EnableAutomaticProxyDiscovery = null,EnableQueryResultDownload="0" ] ){ [Name = CatalogName, Kind = "Database"] }[Data], " select CLASS,RANK from dm.dm_td_aia_class_rank " & UsingLimit, null, [ EnableFolding = true ] ), #"Filtered Rows" = Table.SelectRows(Source, each ([CLASS] <> null and [CLASS] <> "" and [CLASS] <> "Others")) in #"Filtered Rows" ``` annotation PBI_NavigationStepName = Navigation annotation PBI_ResultType = Table