Pbi - Service

[Anonymous]

Hi,

Does any one has experience in dealing power bi file with 3 gb data?
If yes - may I know your report loading time in pbi service?
Thanks in advance.

[nickyvv]

Hi @Anonymous,mi

depending in your data model, the structure of the data and if you use incremental refresh your mileage may very significantly.

Can I ask why you want to know this? Do you have any performance issues?

With a regular Pro license you cannot use a 3 GB file, the maximum is 1 GB (explained here).

[Anonymous]

Hi @nickyvv - Thanks for the reply.
I have a pbix file of 3 gb.When I tried to open it in service it's taking 90sec to load after that it's being very quick for sometime(bcz of caching- it's quick even for other users less than 10 sec). If no one access the report for hours then it's taking 90 sec again.
BTW- I followed all the better practices and optimized the report(analyzed vpax file,used Dax studio,enhance dax ).Once the report is open everything is very quick(interactions)
I just want to know is there a way to reduce  90 sec / is there any flow (power automate) to trigger accessing report automatically at certain intervals so that the report will be quick always?
Thanks in advance.