The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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.
Did you ever find a solution?