Reports performance with licensed concurrent users

[gcanelon]

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.

[v-robertq-msft · Accepted solution]

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.

[gcanelon]

Thanks Roberta. Regards.