Slow loading time with Azure

[gustavjMC]

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

[ibarrau]

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-p...

Hope this helps,