You can query system tables from Power BI. If you modify the PowerQuery to use the system catalog it works. Hereโs an example:
let
Source = Databricks.Catalogs("XXXX.cloud.databricks.com ", "/sql/1.0/warehouses/XXXXX", [Catalog="system", Database="billing", EnableAutomaticProxyDiscovery=null]),
#"Expanded Data" = Table.ExpandTableColumn(Source, "Data", {"account_id", "workspace_id", "record_id", "sku_name", "cloud", "usage_start_time", "usage_end_time", "usage_date", "custom_tags", "usage_unit", "usage_quantity", "usage_metadata"}, {"account_id", "workspace_id", "record_id", "sku_name", "cloud", "usage_start_time", "usage_end_time", "usage_date", "custom_tags", "usage_unit", "usage_quantity", "usage_metadata"}),
#"Removed Columns" = Table.RemoveColumns(#"Expanded Data",{"Name", "Item", "Schema", "Catalog", "Description"})
in
#"Removed Columns"
You'll need an access token or OAuth to connect.