Optimize Refresh Time

[Anonymous]

Hello,

I want to achieve less time for the process "Opening the file", "Refresh the file" and "Save / Publish the file".

The model has two main tables of 2m rows each and some small tables (no more than 1k rows each). 

I'm wondering, if I scale up the ram of the server from 16GB to 32GB (or/and processor -> currently: CPU E5-2686 v4 @ 2.30GHz) is going to decrease the overall process time and save 40%, 50% of the time. 

[KBO]

Hi @Anonymous ,

try this : https://windowsreport.com/refresh-data-power-bi/ 🙂

Remember you can only save files with a limit of 2GB on the Report Server.

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[Anonymous]

Hello @KBO,

Thank you for your time, although the article is not helping me. 

Kind regards