How to improve the refresh time of PBI report

[Anu]

My data model has a lot of data consolidations,it takes around 10 minutes to refresh. What all factors need to be considered to improve the refresh time?
Is power automate used for this purpose?

[Melissa]

Hi Anu,

Power Automate can be used to trigger a refresh for example not for optimization purposes.
And refresh performance can depend on a number of things, see below:

Optimization guide for Power BI - Power BI

Can I improve querying performance of my larger table in Power BI

Hi there, The big thing for me here is that you seem to be doing calculations and summaries in your queries. Personally I would not do this on a large data set because as you’re experiencing it will be very slow. You should look to simplify what you need from your core Sales table and then do any the calculations using DAX measures. This is the most optimized way to do things in Power BI. I’m sure you Sales table doesn’t need to be that wide (or have that many columns). It’s just about gettin…

Is the order of applied steps important in power query

Hi Fredrik, That’s an excellent question. And you are right the order can matter greatly… I’ve found some articles by Chris Webb you’ll find interesting. His recommendations, start by removing all unnecessary columns from your tables, especially if you’re doing transformations such as sorts, merges, groupings, pivots or unpivots. And most optimisations the Power Query engine can use only happen on tables – not records or lists – so you should always try to work with tables whenever you can. F…

.
I hope you find these helpful.

[EnterpriseDNA]

Hi @Anu, we’ve noticed that no response has been received from you since December 29, 2019. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!