Forum Discussion

ROG's avatar
ROG
Responsive Resident
2 years ago

Schedule refresh disabled.

Hello people,   I need your help.    I have a report with data source from databricks, and data gets refreshed in Databricks every evening.   How can I refresh it in PBI also?   Thanks!...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ROG ,

 

Like Ibendlin said, you need a gateway.

 

The local data gateway acts as a bridge. It provides fast and secure data transfer between on-premises data (that is, data not in the cloud) and multiple Microsoft cloud services. These services include Power BI, Power Apps, Power Automate, Azure Analysis Services, and Azure Logic Apps.

 

By using a gateway, organizations can keep databases and other data sources on their local network while also making that local data securely available in cloud services.

 

So if you want to use the databricks data source on Power BI Service and refresh it, please configure a gateway first.

 

Please follow these steps:

 

1. Download and install the Power BI Standard Gateway. For detailed installation steps, you can click on the link below:

Install an on-premises data gateway | Microsoft Learn

 

2. Enter Power BI Service>>Click the small gear icon in the upper right corner>>Select "Manage connections and gateway">>Click "New" above the "Connections" tab to create a new connection>>Select Datarisks and enter the relevant credential information.

 

3. Enter your workspace, select the semantic model you want to refresh, and select settings.

 

4. Under "Gateway and cloud connections", select what you just configured to refresh.

 

If you want to learn more about gateways and refresh, please refer to the following documentation:

Use the on-premises data gateway app | Microsoft Learn

Add or remove a gateway data source - Power BI | Microsoft Learn

Configure scheduled refresh - Power BI | Microsoft Learn

 

I would be grateful if you could provide details of the error if you still have no success after doing this.

You can also use Service Principal to refresh Power BI datasets and manage PATs by incorporating best practices.

 

Here is a reference from someone who had a similar problem to you and solved it:

Solved: Power BI - Databricks Connection using Service Pri... - Databricks - 50821

 

If you have any further questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!