Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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.

2 REPLIES 2
Neeljy
Regular Visitor

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
New Member

Did you ever find a solution?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors