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 connecting the same Power BI report to the same database but on a local SQL-server.

 

I first tried 10 DTU's but that was incredibly slow, I then tried 20 DTU's, still slow. I'm now running on 2 vCores which I believe is the maximum on a free trial but it's still very slow.

 

Anyone experiencing the same thing? Do you need even more vCores to be able to use power bi in a smooth way?

 

Best regards

Need Help

1 Reply

  • 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,