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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Power BI Embedded and Azure Databricks SQL Warehouse Integration issues

We are using Power BI embedded for Data Visualization from Azure Databricks Delta Lake Tables via Direct Query Mode

 

As per documentation while connecting to a SQL Warehouse from Power BI using Azure Databricks Connector we supply 2 part connection string

  1. Server hostname
  2. HTTP path

 

Earlier SQL Warehouses were referred as SQL Endpoints and HTTP Path was {/sql/1.0/endpoints/[clustered]} , since the introduction of SQL Warehouses HTTP Path is changed to {/sql/1.0/warehouses/[clusterId]}

 

After Embedding Power BI Reports with new SQL Warehouse connection {/sql/1.0/warehouses/[clusterId]} , Power BI Embedded Reports are unable to connect to Databricks , if we change this connection to {/sql/1.0/endpoints/[clusterId]  for same SQL warehouse, Power BI Reports are able to connect to Databricks

 

Reports are Embedded Programatically using Power BI REST API and SDK 

In one of the Steps of Report Embedding - Datasource Credentials are required to be refreshed for Report to work in Embedded Service , this is done via REST API - https://learn.microsoft.com/en-us/rest/api/power-bi/gateways/update-datasource#oauth-2.0-credentials...

 

Please can anyone share if they had similar issues and possible solutions or best practices 

 

Thanks

Status: Investigating

Hi @bhushant ,

 

You can connect Power BI Desktop to your Azure Databricks clusters and Databricks SQL warehouses by using the built-in Azure Databricks connector. You can also publish Power BI reports to the Power BI service and enable users to access the underlying Azure Databricks data using single sign-on (SSO), passing along the same Azure Active Directory credentials they use to access the report.

 

Connect to Power BI - Azure Databricks | Microsoft Learn

 

Best Regards,
Community Support Team _ Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi @bhushant ,

 

You can connect Power BI Desktop to your Azure Databricks clusters and Databricks SQL warehouses by using the built-in Azure Databricks connector. You can also publish Power BI reports to the Power BI service and enable users to access the underlying Azure Databricks data using single sign-on (SSO), passing along the same Azure Active Directory credentials they use to access the report.

 

Connect to Power BI - Azure Databricks | Microsoft Learn

 

Best Regards,
Community Support Team _ Caitlyn

bhushant
Regular Visitor

Hi @v-xiaoyan-msft  - Thanks for responding , I understand we can connect to Azure Databricks SQL Warehouses using PBI Desktop and Service via Azure Databricks Connector. The issue we are facing is relaetd to the connection string used in Azure Databricks SQL Warehouses.

 

As SQL Endpoints were renamed to SQL Warehouses the connection String of HTTP Path has changed from {/sql/1.0/endpoints/[clusterId]} to {/sql/1.0/warehouses/[clusterId]}. 

 

When Reports are Embedded to PBI Service programatically using PBI sdk and REST API, after updating the Datasource credentails with reports using connection of {/sql/1.0/warehouses/[clusterId]} stops working.

 

Same Reports and Embedding works if the connection is chanegd to {/sql/1.0/endpoints/[clusterId]}.

 

If there are others methods to Embedd Reports for Azure Databricks SQL Warehouses connections, please let me know 

 

Thanks