Refresh too slow in Desktop

[learner03]

I have a data set in which one of the table has around 35,000 rows after the trasformation steps. The other 5 table just have under 1,000 rows. The 5 tables gets loaded pretty quickly but the table that has few transformation steps takesmore than 1 hour to refresh. My data source is from a custom connector provided by the warehouse management system people.

How can I make this faster?

[v-xulin-mstf · Accepted solution]

Hi @learner03

You can optimize Power BI Report in Desktop as the following steps:

1. Optimizing the data model
2. Optimizing visualizations
3. Monitoring performance

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[amitchandak]

@learner03 , what are the transformation step. Does it include any cross join (full outer join)?

[learner03]

@amitchandak  no it doesn't have cross join etc. It has basic filters such as taking data from 1st July, removing some unnecessary  columns,  filtering certain columns based on a type of storage type such as Bulk.