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/
Post ProdigyMy data is held in an Azure SQL so I wasn't worried about using an on premises gateway.
So if I change the column types in my sql table it will recognise the datetime data type and I'll be able to work with it using DirectQuery?
Super UserI cannot say 100%, but I am fairly certain it should work yes.
- 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 - ElliotP
Ideal.
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?
- GilbertQGlad to have help