cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
arun1780
New Member

Need details on Power BI Visuals Auto refresh for Import model

Hi,

 

              I am looking to do an Auto refresh on Report Page (Visuals) or Dashboard Visuals, (for every 15 mins) which is based on Import model, apart from the Data Refresh. Please share me, if you have come across any such scenario in Power BI Reports

1 ACCEPTED SOLUTION

Hi @arun1780 

As you've seen the Auto Page Request option is only for Direct Query Datasets. Viewing a Report based on a Import Dataset does not auto update, it requires the user to refresh the web browser, or close and open the report. You can automate this with one of several Browser Extensions (dependant on your Browser type) for Edge you can use things like this Smart Auto Refresh - Microsoft Edge Addons

However  this will only load the data from the Dataset, if the Browser auto refresh is set for 15 minutes, but the Dataset only refreshes every 30 minutes you'll only see a change every 30 minutes.

Hope this helps

Stuart

View solution in original post

3 REPLIES 3
Burningsuit
Solution Sage
Solution Sage

HI @arun1780 

There seems little point in refreshing Reports and Dashboards on an Import model every 15 minutes if the underlying Dataset is not refreshed as well. So I assume you asking about alternative ways of refreshing the Dataset every 15 minutes. You can do this with Power AUtomate (flow) Refresh your Power BI dataset using Microsoft Flow | Microsoft Power BI Blog | Microsoft Power BI or with the Power BI REST API Datasets - Refresh Dataset - REST API (Power BI Power BI REST APIs) | Microsoft Docs.

Note that all refresh methods honour the Power BI licencing restrictions. That is, if you only have a Pro licence, up to 8 automated refreshes per day with 30 minutes between refreshes. You'll need a Premium Per User account or Premium Capacity, which will allow up to 48 refreshes per day with 1 minutes between refreshes to get Import Datasets updated every 15 minutes. 

Hope this helps

Stuart

Hi,

 

      Thanks for the reply, Am not asking for the data refresh, it's about the Visuals refresh.

for DQ model, we have Auto page refresh (screenshot), similar to this i need to set an auto refresh on visuals based on import Model.

arun1780_0-1637230844476.png

 

Hi @arun1780 

As you've seen the Auto Page Request option is only for Direct Query Datasets. Viewing a Report based on a Import Dataset does not auto update, it requires the user to refresh the web browser, or close and open the report. You can automate this with one of several Browser Extensions (dependant on your Browser type) for Edge you can use things like this Smart Auto Refresh - Microsoft Edge Addons

However  this will only load the data from the Dataset, if the Browser auto refresh is set for 15 minutes, but the Dataset only refreshes every 30 minutes you'll only see a change every 30 minutes.

Hope this helps

Stuart

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors