Connect power bi desktop semantic model output to databricks

[madhumitha]

Hello, I am trying to connect the power bi semantic model output (basically the data that has already been pre processed) to databricks. Does anybody know how to do this? I would like it to be an automated process so I would like to know any way to pull the data from the power bi desktop directly to databricks.

[Kaniz]

Hi @madhumitha, Connecting Power BI semantic model output to Databricks can be done in a few steps.

Here are a couple of options:

1. Databricks Power Query Connector:
   • The new Databricks connector is natively integrated into Power BI. You can configure connections to Databricks with just a few clicks.
   • In Power BI Desktop, follow these steps:
     1. Select “Get Data.”
     2. Search for “Databricks” to shortlist the Databricks connector.
     3. Authenticate once using Azure Active Directory (AAD).
     4. Enter the Databricks-specific connection details.
   • Once configured, you’ll be ready to query the data directly from Databricks¹.

2. Azure Databricks and Power BI Integration:
   • Power BI’s strong enterprise semantic modeling and calculation capabilities allow you to define calculations, hierarchies, and other business logic meaningful to you.
   • Azure Databricks and the lakehouse orchestrate the data flows into the model.
   • This integration provides a seamless way to connect your Power BI semantic model to Databricks².

Choose the approach that best suits your requirements, and you’ll be able to automate the process of pulling data from Power BI Desktop to Databricks. 🚀³².

[madhumitha]

Hello,

Thank you for your reply and help! I realised I need to connect to the online power BI version  as I am connecting to the updated semantic models that is updated by someone else onto power bi online (workspaces). 

do you know if the same connection you sent in the article is applicable to this? Thanks!

[Kaniz]

Hi @madhumitha, Connecting to semantic models in the Power BI service from Power BI Desktop is a useful feature when working with shared data models.

Here’s how you can establish a live connection to a published semantic model in the Power BI service:

1. In Power BI Desktop:

   • Go to the Home tab.
   • Select Get data > Power BI semantic models.
   • Alternatively, you can select Get data, then on the Get Data screen, choose Power Platform in the left pane, and then select Power BI semantic models.
   • If you’re not signed in, Power BI will prompt you to sign in.
   • The Data hub will display the workspaces you’re a member of and all the shared semantic models you have Build permission for in any workspace.

2. Select a semantic model:

   • Choose the relevant semantic model that you want to connect to.
   • Click Connect to establish a live connection to the selected semantic model.
   • Power BI Desktop will load the semantic model fields and their values in real time.

3. Now, you and others can create and share custom reports based on the same semantic model. This approach ensures consistency and makes it easier to collaborate on reports and dashboards acros...¹.

Remember that this method allows you to create multiple reports in .pbix files from the same semantic model and save them to different workspaces. It’s a great way to work with shared data models efficiently! 😊📊

If you need further assistance or have any other questions, feel free to ask! 🚀

[Kaniz]

Hi @madhumitha, Thank you for reaching out to our community! We're here to help you.

To ensure we provide you with the best support, could you please take a moment to review the response and choose the one that best answers your question? Your feedback not only helps us assist you better but also benefits other community members who may have similar questions in the future.

If you found the answer helpful, consider giving it a kudo. If the response fully addresses your question, please mark it as the accepted solution. This will help us close the thread and ensure your question is resolved.

We appreciate your participation and are here to assist you further if you need it!

[madhumitha]

Hello, thank you for your help!

I think you might have misunderstood my question😅I am looking to read the semantic model data from the power bi service directly to databricks. Or from my workspace, I want to read the data directly to databricks where I can perform some data query. Thanks!