topic Re: Optimize Refresh Time in Report Server

Optimize Refresh Time

Anonymous — Wed, 26 Feb 2020 07:27:34 GMT

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.

Re: Optimize Refresh Time

KBO — Sun, 01 Mar 2020 16:48:38 GMT

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!

Re: Optimize Refresh Time

Anonymous — Tue, 03 Mar 2020 08:46:12 GMT

Hello KBO,

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

Kind regards