Forum Discussion

ElliotP's avatar
ElliotP
Icon for Post Prodigy rankPost Prodigy
9 years ago
Solved

Refresh Every 5-10 minutes

Evening,   I was wondering if it was possible with a pro license (or even a free) to refresh a dashboard/report every 5-10minutes?   I've seen the option to use streaming analytics but I'm not su...
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi ElliotP

     

    If you are connecting using Azure SQL Database, it is by default then connecting using DirectQuery. So what that means is that everytime you click on something in your report, it is sending a query back to your Azure SQL Database in realtime and returning the results.

     

    Your dashboards are automatically refreshed every 15 minutes, and there is the possibility to change this in the service.

     

    You can find more details with this here: https://powerbi.microsoft.com/en-us/documentation/powerbi-azure-sql-database-with-direct-connect/