As part of an update to Kodiak Hub's platform, the tables that support your Power BI reports have moved to a new location using Azure Databricks. This guide walks you through updating your report. Your report's layout, visuals, and calculations should not change — only the underlying data connection.
You will need to repeat the steps below once for each table in your report that is affected by this change. Your Kodiak Hub contact can tell you which tables need updating.
Before you start
note
ff7b9b8a-74bf-4804-9645-f5efb7c78c61
You will need the following connection details, which will be provided by your Kodiak Hub contact if you don't already have them:
Host name
HTTP path
Client ID
Client secret
The schema and table name for each table you are updating
You will need the following connection details, which will be provided by your Kodiak Hub contact if you don't already have them:
Host name
HTTP path
Client ID
Client secret
The schema and table name for each table you are updating
Step 1: Open the query editor
In your Power BI file, go to Home → Transform Data to open the Power Query editor.
Step 2: Remove the outdated table
Select the table you are updating in the Queries panel and delete it. Don't worry — you'll recreate it with the same name in the next steps, so any visuals built on it will reconnect automatically once the new table is in place.
Step 3: Connect to the new data source
Select New Source → Azure Databricks → Connect.
Step 4: Enter your connection details
Enter the host name and HTTP path you were given, along with the catalog name, in the connection window:
OPTIONAL: Scroll down to the "Native Query" field and enter a query using the schema and table name provided to you, in this format:
wide
760
Select OK.
On the sign-in screen, choose Databricks Client Credentials as the authentication method, then enter your Client ID and Client secret in the corresponding fields.
Step 5: Preview the data
If a preview window appears showing a sample of the new data, review it and select OK to continue.
Step 6: Rename the new table
This step is essential. Power BI names new queries "QueryX" by default. Rename it to match the exact name of the table you deleted in Step 2. This is what allows your existing visuals, measures, and relationships to reconnect to the new table automatically — skipping this step will break your report.
Step 7: Repeat for each remaining table
Go back to Step 2 and repeat the process for every other table in your report that needs to be migrated.
Step 8: Apply your changes
Once every table has been updated and renamed, select Close & Apply.
Step 9: Confirm everything works
Power BI will reload your semantic model. Once this finishes, check your report visuals to confirm the data is displaying correctly. Your report is now ready to be republished to your Power BI workspace.
note
c07c0aa6-b11e-4c3c-93fb-7e784ddc81b6
If anything looks off after migrating — missing data, broken visuals, or connection errors — reach out to [email protected]
If anything looks off after migrating — missing data, broken visuals, or connection errors — reach out to [email protected]