Issue with Scheduled Refresh (On Prem Server) if Dadabricks Token used in the Dashboard

[GZakir]

Hello everyone,

We are moving from Sql Server to Databricks.

And we started changing the Data Source from SQL to Databricks on Dashboard

But, we are not able to Schedule a Job to run Refresh because we are using Databricks Token to connect Databricks.

How we can schedule a job if Dashboard is connecting to Databricks using Token.

Can someone help.

Regards,

Zakir

[R1k91]

are you using power bi report server?

are you sure databricks to be a supported source? 

couldn't see it in the docs Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn

[GZakir]

Yes Databricks is supported source as I am able to connect .

[R1k91]

"

Some data sources are available in Power BI Desktop that is optimized for use with Power BI Report Server, but they aren't supported when published to Power BI Report Server.

"

[pradeep_kare12]

You'll need to install and configure an on-premises data gateway on a machine within your network. This gateway will act as an intermediary between power bi service and your databricks cluster. Download and install the power bi on premises data gateway, configure the gateway with the necessary settings to connect to your databricks cluster. To use Databricks REST APIs for data refresh, you can create a custom connector in Power BI. Open Power Query go to home, get data, blank query. In the formula bar you can enter your custom M code to call Databricks REST APIs. You can use functions like Xml.Document or Json.Document to parse the API response. Once you have the custom connector set up, you can use it in a power query to refresh data from your Databricks cluster. Then you can schedule data refresh within Power BI Desktop using the Home, transform data , Query options and Scheduled Refresh.