Forum Discussion

gcanelon's avatar
gcanelon
Frequent Visitor
5 years ago
Solved

Reports performance with licensed concurrent users

Hello. 

 

We are creating a report in Power BI Desktop with approximatelly 30 visuals distributed in 5 pages. The data is imported and has a size of about 1 GB, there are no DirectQuery conections. We plan to publish this report to the service to share it with our Pro licensed users. We expect to have about 300 concurrent users. Should we expect performance issues? If, so, how can we manage them? 

 

Thanks in advance.

Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, gcanelon 

    I think that if you import mode, the risk of performance issues can be very low. Because all data is cached in power bi service. If the report is using Direct Query to on-premise datasource and a large number of users are accessing that report then I would expect some performance issues since each time user interacts with visual on report query is sent on-premise to datasource.

    What’s more, I suggest you set the scheduled refresh in the period of idle time(like midnight). In order to ensure sufficient memory space and higher refresh efficiency.

    More advice of data refresh you can take

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-robertq-msft's avatar
    v-robertq-msft
    Community Support
    5 years ago

    Hi, gcanelon 

    I think that if you import mode, the risk of performance issues can be very low. Because all data is cached in power bi service. If the report is using Direct Query to on-premise datasource and a large number of users are accessing that report then I would expect some performance issues since each time user interacts with visual on report query is sent on-premise to datasource.

    What’s more, I suggest you set the scheduled refresh in the period of idle time(like midnight). In order to ensure sufficient memory space and higher refresh efficiency.

    More advice of data refresh you can take

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.