Announcing Power BI integration with Databricks Partner Connect

-

Power BI Desktop customers can now visualize data in Delta Lake using Databricks with just a couple of clicks. In the past, connecting to Databricks from Power BI Desktop required the end user to perform a lot of manual configuration. Power BI Desktop integration with Databricks Partner Connect makes it simple to connect to Delta Lake so you can start doing analytics and sharing insights with your business.

Databricks Partner Connect is a one-stop portal for customers to quickly and easily discover a broad set of certified data, analytics, and AI tools and easily integrate them with Databricks. Integration with Microsoft Power BI Desktop is included at launch, and many more integrations are coming in the months ahead.

Connecting Power BI Desktop to Databricks used to require a lot of complex configuration. With Partner Connect, you can just download a connection file that contains all the information you need to connect to Databricks, removing the need for complex configuration.

Power BI Desktop integration with Partner Connect helps make self-service BI a reality by making it easy for end users to create their own dashboards and get the freedom to analyze, publish and share insights with others.

 

How does it work?

To get started, click on the Power BI icon in Partner Connect (in the sidebar), select a compute endpoint, and download the Power BI data source file. When you open the file on a computer with Power BI Desktop installed, you will be prompted to enter your credentials and will be able to connect to the chosen compute endpoint. Once connected, you can query and visualize data at lightning speed and share insights with your team.

How does BI work on Partner Connect? 1. Select a BI partner in Partner Connect. 2. Select an endpoint and download the connection file. 3. Open the connection file. 4. Enter credentials. 5. Query and visualize

  1. From the Partner Connect tab, click on the Power BI icon.Power BI icon in Partner connect
  2. Choose a compute endpoint.Selecting compute endpoint (serverless) and downloading connection file.
  3. Download and open the connection file using Power BI Desktop 2.85.681.0 or above.
  4. Sign in using Azure Active Directory (Azure AD) credentials, Personal Access Token (PAT), or the Databricks workspace username and password. DirectQuery enables direct access to data in Databricks, providing fresh data while enforcing Delta Lake security controls so there is no need to duplicate security controls in Power BI.
  5. Navigate tables and views to start visualizing your data and performing analytics.
Partner Connect is now available to Databricks customers at no additional cost.

Comments

  1. ram k11 January 2022 at 21:09

    Great article, Thank you for sharing this valuable info with us.

    ReplyDelete

Post a Comment

Popular posts from this blog

Failed to execute the package or element. Build errors were encountered

-
Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element.   Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------   Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package
Read more

Restore of database 'DataBase_Name' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

-
TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore of database 'DataBase_Name' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks) ------------------------------ ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: Exclusive access could not be obtained because the database is in use. (Microsoft.SqlServer.SmoExtended) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.2000.8+((SQL14_RTM).140220-1752)&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Procedure 1: 1. Right click Databases 2. Restore Database... 3. [General] Source from Device, select the bak file 4. [General] Change the Destination database name to a new name 5. [Files] Change mdf and ldf Restore As paths to a different, new path 6. [Options] (unnecessary on the other computer) Check Overwrite the existing database (WITH_REPLACE) 7. [Options] (unnecessary on the other computer) Chec...
Read more

On-premises data gateway December release

-
We are happy to announce that we have just released the December update for the on-premises data gateway (version 3000.154.3). This update brings the on-premises data gateway up to date with the December release of Power BI Desktop. Download:  On-premises data gateway December release This version of the gateway will ensure that the reports that you publish to the Power BI Service and refresh via the gateway will go through the same query execution logic/run-time as in the December version of Power BI Desktop.
Read more