Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Optimize Refresh Time

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. 

2 Replies

  • KBO's avatar
    KBO
    Memorable Member

    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's avatar
      Anonymous
      Not applicable

      Hello KBO,

       

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

       

      Kind regards