Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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" 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.

Need Help

2 Replies

  • Neeljy's avatar
    Neeljy
    Regular Visitor
    1 year ago

    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.