Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Pbi - Service

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.
Need Help
nickyvv's avatar
nickyvv
Most Valuable Professional
4 years ago

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

    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.