Import Query dataset refresh for every 30 minutes

[ShakilaDe]

Hi All,

Is it any option to reload the Power BI dataset for every 30 minute per day (more than 12-18 runs) under Import  query options?

Regards,

Shakila D

[Seth_C_Bauer · Accepted solution]

@ShakilaDe Pro license allows for 8 refreshes per day. Premium license is documented at 48x per day although a different user has seen that in the Service it is unlimited, so maybe that is a recent change.

[Anonymous]

I think you can use this, I'm using it for 1 year now and it spared me a lot of searches and headaches

you can resfresh the data every 2 minutes if you want, and for unlimited number of workbooks

Power BI scheduled refresh more than 8 times a day

unless you already found a better option

[TomMartens · Accepted solution]

Hey,

depending on your datasource just Power BI Premium offers a data refresh rate that can be scheduled up 48times per day (every 30 min): https://powerbi.microsoft.com/en-us/power-bi-premium/

Without Premium you are limited to 8 times per day.

Maybe you have to consider using on-premises data (assuming you data source supports direct query or live connection), here the user just needs to refresh the report. Here is a link to a more detailed about Data refresh, this link also contains a list of data sources that support direct query or live connection.

Hopefully this is what you are looking

Regards

Tom

[Seth_C_Bauer · Accepted solution]

@ShakilaDe Pro license allows for 8 refreshes per day. Premium license is documented at 48x per day although a different user has seen that in the Service it is unlimited, so maybe that is a recent change.

[ShakilaDe]

Thanks for the response Seth_C_Bauer,I'm having Pro license so I only able to refresh 8 refreshes per day. But i required to reresh the dataset for every 1 hour(24 times/ day).

Is there any alternates to achieve this?

[Anonymous]

Hi,

I had a similar requirement. 

Data source -> ODATA connection

Since the number of data refresh are limited to 8 (for Pro), i used AHK scripting to automate data refresh. Have pasted the refresh scipt below.  This script (automates the manual way of refreshing PowerBI Online reports) will automatically click the 'refresh now' button of the dataset in PowerBI online and refresh the report also. 

Note -> Please change the screen coordinates to your screen coordinates & Update the Report link. 

Instead of giving buttons, you can add a time interval after which the script will repeatedly execute. 

----

gui, add, button, x5 y10 h20 w140 gsub1, View Existing Dashboard ;
gui, add, button, x5 y40 h20 w140 gsub2, Refresh Data ;
gui, add, button, x5 y70 h20 w140 gexit, Exit Script
gui, show, w150
return

sub1:
{
Run, chrome.exe "REPORT LINK"
}
return

sub2:
{
msgbox, Data refresh in progress!
Run, chrome.exe "https://app.powerbi.com/groups/me/list/datasets"
sleep, 20000
MouseMove, 250, 539
sleep, 200
Click
sleep, 5000
MouseMove, 254, 945
sleep, 200
Click
sleep, 5000
MouseClick, left, 320, 625
sleep, 20000

Run, chrome.exe "REPORT LINK"
sleep, 25000
MouseMove, 681, 173
sleep, 200
Click
}
return

guiclose:
exit:
{
exitapp
}
return

Thanks!

[Seth_C_Bauer]

@ShakilaDe Not unless you are able to use Direct Query or Live Connection. (Database/SSAS server). You are limited to 8x per day, regardless of whether you initiate from the Service or API

[ShakilaDe]

Okay thank you all..