Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
Hope this helps,
Happy to help!