bhushant's avatar
bhushant
Frequent Visitor
3 years ago
Status:
Investigating

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 Az...
APIS and Embedding
bhushant's avatar
bhushant
Frequent Visitor
3 years ago

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

 

Completed Ideas