Power BI Embedded and Azure Databricks SQL Warehouse Integration issues

[bhushant]

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

[Anonymous]

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]

Hi @Anonymous  - 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