Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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