Forum Discussion
PowerBI Reports on Databricks Unity Catalog Impact
Dears As we move to Databricks Unity Catalog from current hive catalog, we notice the PowerBI reports we built by connecting to Databricks are impacted. The current hive metastore "hive_metastore"...
You could use Power BI REST APIs or Tabular Editor to automate the metadata updates across reports. Specifically: Power BI REST API:Export the dataset definitions, search for "hive_metastore", and replace it with "lakehouse_dev". Then, update the reports via the API. Tabular Editor (for datasets in Power BI Premium): Open the dataset, perform a bulk find-and-replace on "hive_metastore", and save the changes. PowerShell or Python Script: Use the Power BI API to iterate over all reports and automate updates.