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

2 Replies

  • nickyvv's avatar
    nickyvv
    Icon for Most Valuable Professional rankMost 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.