PowerBI Reports on Databricks Unity Catalog Impact

[Anonymous]

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" name is deeply there in the data sets definiions within PowerBI.
We need a way to find the current hive catalog name "hive_metastore" and replace with the new catalog name "lakehouse_dev" for example.

Appreciate your support please in ideas exchange or any automation script. We have 100+ reports and cannot afford manual changes.

Br,
Noor.

[Neeljy]

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.

[SRR]

Did you ever find a solution?