Slow refreshing time when I am combining different queries from the same file

[Anonymous]

Hi,

I am experiencing very slow refreshing time when I am combining different queries from the same file. The "problem" is Power query is processing all the steps for every query, so it loads the file every query. The file it isn't very big (around 20mb), but the refreshing time is really high and I can see in the right side corner that the mb loaded is the file size multiplied by the number of queries. 

Any ideas?

I am attaching an image of the queries.

[Anonymous · Accepted solution]

In this forum I have found a solution:

https://www.myonlinetraininghub.com/excel-forum/power-query/any-way-to-speed-up-really-slow-refresh-...

[v-yuta-msft]

@Anonymous ,

This is depend on the power query you are using. Generally, you can cut most useless "table scanning" query as possible as you can. In addtion, in File-> Options, select all the options in Query reductions as below:

  

You may also refer to tips in doc and blog below which may help you improve performance:

https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance

http://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques

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]

Thank you @v-yuta-msft but your solution is not working. After power query have transform the data the power BI visuals are working at a reasonable speed.

The slow refreshing ocurs only during the data transformation into a new table in power query.

All the documentation attached is refered to improve the reports and visuals perfomance, not data transformation perfomance. 

Best regards,

[v-yuta-msft]

@Anonymous ,

You can try reducing variables and reducing the number of columns and iteration times in your power query code. Below is some blogs about how to improve performance of power query.

http://radacad.com/watch-your-steps-power-query-performance-caution-for-power-bi

https://www.excelando.co.il/en/analyzing-power-query-performance-source-large-files/

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.