topic Can Power BI report Builder connect to Azure Databricks? in Report Server

Can Power BI report Builder connect to Azure Databricks?

anikah123 — Thu, 16 Jan 2025 00:23:53 GMT

Hi all,

I am working on migrating SSRS reports to Power Report Builder. The data source is Azure Databricks, and I need to know if Power BI Report Builder can connect and refresh the data connecting to azure Databricks.

Thanks,

Kavitha

Re: Can Power BI report Builder connect to Azure Databricks?

d_gosbell — Thu, 16 Jan 2025 22:13:40 GMT

If you are using the cloud service to host your paginated reports then you can use the "Get Data" button to connect to Azure Databricks. But this functionality uses some of the Power Query Online services in the backend so it does not work in the on-prem Report Server.

Re: Can Power BI report Builder connect to Azure Databricks?

Anonymous — Fri, 17 Jan 2025 09:31:36 GMT

Hi, anikah123

You can use Power Query Online to connect to these data sources from Power BI Report Builder and create datasets that you can use in paginated reports. You can check the following link:

Connect paginated reports to data sources using Power Query - Power BI | Microsoft Learn

This is a new feature and is currently in preview, so there are limitations when you can use it

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.