Forum Discussion
Post ProdigyRefresh Every 5-10 minutes
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/
Super UserI cannot say 100%, but I am fairly certain it should work yes.
Post ProdigyIdeal.
I noticed my DTUs spiked dramatically and maxed out when Direct Query was pulling. It took a solid 20 seconds for the visuals to appear when i clicked on certain visuals. Do I simply need more DTU's?
- GilbertQHi there.
What I would suggest doing if it is taking so long is to look at ensuring that you have the correct indexes and joins in place so that the query can run as efficiently as possible.
Also look at column store indexes which can help improve query performance also - GilbertQGlad to have help