Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 sure how I would be able to use this as well as apply my transformations in powerbi desktop as so the end user sees my work with the data.
I've seen the option for DirectQuery, but from what I've read I encounter the same issue as immedaitly above.
Solved! Go to Solution.
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/