Forum Discussion

ShakilaDe's avatar
ShakilaDe
Frequent Visitor
8 years ago
Solved

Import Query dataset refresh for every 30 minutes

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
General Comment
  • Anonymous's avatar
    Anonymous
    8 years ago

    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.

  • TomMartens's avatar
    TomMartens
    8 years ago

    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

ShakilaDe's avatar
ShakilaDe
Frequent Visitor
8 years ago

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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!