Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
I have Power Bi report which using the Direct query and it is taking longer time to load. My report contains multiple visuals to render the data which is taking more time.
Solved! Go to Solution.
@Anonymous ,
If you model is too complicated, the query sent to data source will also be complicated in direct query mode. You need to simplify your data model as possible as you can. I would suggest you refer to blogs below about how to improve the data model in power bi.
https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
If you model is too complicated, the query sent to data source will also be complicated in direct query mode. You need to simplify your data model as possible as you can. I would suggest you refer to blogs below about how to improve the data model in power bi.
https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the information and my report contains Direct query multiple slicers for selection which are required.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.