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

Anonymous's avatar
Anonymous
Not applicable
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.

ShakilaDe's avatar
ShakilaDe
Frequent Visitor
8 years ago

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      ShakilaDe
      Frequent Visitor
      8 years ago

      Okay thank you all..

  • 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!