cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rahulstomar08
Frequent Visitor

data refresh

Is there any way to automatic refresh the Power Bi data when the data get update in data source in import mode.

I know it is possible with DirectQuery, but is there any way in import mode?

1 ACCEPTED SOLUTION

Hi @rahulstomar08 

There's a couple of things you could do here. One is to use Power Automate

Schedule Refresh Power BI dataset with Power Automate! | by Nimai Ahluwalia | All About Power BI | M...

Power Automate can take a "trigger action" (maybe data added to your datalake) and then run a Refresh on a Power BI dataset.

An alternative would be to use a programming language that supports REST calls to run the refresh.

Asynchronous refresh with the Power BI REST API - Power BI | Microsoft Docs

Note both these methods will not get around the 8 automated refreshes per day as each refresh will count. So if your datalake gets updated more frequently you'll miss out, or need to move to a PPU or Premium Capacity which allows up to 48 refreshes per day.

Hope this helps

Stuart  

 

View solution in original post

5 REPLIES 5
rahulstomar08
Frequent Visitor

I don't want scheduled refresh. I want that whenever my data get updated in data lake my dataset should get refresh automatically.

Can you please help in this?

HI @rahulstomar08 

No, if you've used import mode to get the data into the Datamodel the only refresh options you have is Scheduled Refresh. Direct Query does what you want, if your database server can support the extra load.

Hope this helps

Stuart

Hi @Burningsuit 

Thank you!

Can we use push dataset ?

I don't know much about it.

 

Rahul

Hi @rahulstomar08 

There's a couple of things you could do here. One is to use Power Automate

Schedule Refresh Power BI dataset with Power Automate! | by Nimai Ahluwalia | All About Power BI | M...

Power Automate can take a "trigger action" (maybe data added to your datalake) and then run a Refresh on a Power BI dataset.

An alternative would be to use a programming language that supports REST calls to run the refresh.

Asynchronous refresh with the Power BI REST API - Power BI | Microsoft Docs

Note both these methods will not get around the 8 automated refreshes per day as each refresh will count. So if your datalake gets updated more frequently you'll miss out, or need to move to a PPU or Premium Capacity which allows up to 48 refreshes per day.

Hope this helps

Stuart  

 

Burningsuit
Super User
Super User

Hi @rahulstomar08 

Datasets on Power BI service can be refreshed an an automatic basis. Look at the "Settings" options on the Dataset, there you can set the Gateway connection. (Gateways are required if the original data in on premise, but not required if the data is online in a cloud repository). For cloud based data you provide the login credentials.

With these settings correct, you can schedule automatic refresh, up to 8 time per day for Pro licence, 48 times per day for PPR and better licences.

Data Refresh is a bitg topic in Power BI, with many options and settings, take a look at the Microsoft Documentation first, and go from there: Data refresh in Power BI - Power BI | Microsoft Docs

Hope this helps

Stuart

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors