cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results for 
Search instead for 
Did you mean: 

Change Databricks Connection on Power BI (service)

mbhakta
New Contributor II

We're creating a report with Power BI using data from our AWS Databricks workspace. Currently, I can view the report on Power BI (service) after publishing. Is there a way to change the data source connection, e.g. if I want to change the data source from Dev to Prod data or a different workspace? 

3 REPLIES 3

Kaniz_Fatma
Community Manager
Community Manager

Hi @mbhaktaYes, you can change the data source connection for your Power BI report.

Here are the steps:

1. Go to the Power BI service and locate the dataset for your report.
2. Expand the "Data source credentials" section and click "Edit credentials".
3. In the configuration dialogue, you can update your data source details accordingly.

Remember, you need to have the necessary permissions to perform these changes.

Also, if you have enabled single sign-on (SSO) for your report, you will need to manage access to the data source using the Azure AD identity of the user accessing the report.

mbhakta
New Contributor II

Hi @Kaniz_Fatma,

Thanks for your reply! It seems possible, but I'm stuck on step 3, since `extensionDataSourcePath` is greyed out. Everything else is editable. What permissions do I need in order to update that field? 

Screenshot 2023-08-21 134828.png

Srushti
New Contributor II

Have you got any solution for this?

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!