Forum Discussion
Can Power BI report Builder connect to Azure Databricks?
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
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.
2 Replies
- d_gosbell
Super User
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.
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.
