Forum Discussion

gustavjMC's avatar
gustavjMC
Frequent Visitor
5 years ago

Slow loading time with Azure

Hello,   I'm currently trying out how it is to use DirectQuerys in Power BI with Azure SQL server. What I've found out is that my reports are loading much slower with Azure than it does when connec...
Need Help
ibarrau's avatar
ibarrau
Super User
5 years ago

Hi!, first of all. Direct Query is not for any data source. I would only recommend it with Warehouses (snowflake, synapse, redshift). I would also recommend reading about Power Bi Aggregations that might be a key point on the data model in order to make it faster.

I'm leaving here a documentation with the best practices to do direct query. If you do them and it's still slow, don't increase the DB, consider aggregations or synapse. Databases are prepared for transactional data and not for analytics.

https://docs.microsoft.com/en-us/power-bi/guidance/directquery-model-guidance#optimize-data-source-performance

 

Hope this helps,