Forum Discussion
Online Service - Concurrent Users
Hi,
I have been developing a report over the last year or so and slowly rolling it out over our organisation (a group of 13 schools). I have got to grips with the development side of Power BI/DAX but, beyond pushing the Publish button, I'm pretty ignorant when it comes to networks/servers/cloud etc!
We had a partial rollout at one of our bigger schools, got about 60 people ready to go and planned on talking them through the online report and how they can use it (they all have Pro accounts (trials for now) )
Once they all logged in the service pretty much fell over. Drop down page selectors didn't work and graphics didn't fully load etc so we abandoned the rollout/training session. Pretty much nothing would load.
Is 60 too many concurrent users for the online report? The report is pretty complex - RLS, multiple pages accessed via drop down box to control page access, slicers on most pages etc. The dataset sits at 184mb on the online service.
Is the fall over likely a one off, is Premium the answer (I'm not sure it's cost effective with around 250-300 users in total), or should I be rebuilding simpler version of the report?
Just a reminder, please talk to me like I'm an idiot! I have a decent grasp of Power BI development, but service delivery is just a magic button to me!
Thanks 🙂
Hi, JohnHedges
This is usually related to the connection mode of your report.
If you are currently using import mode, data is cached in power bi service and the risk of performance issues is probably very low. If you are using DirectQuery and a large number of users are accessing the report online at the same time, there will inevitably be some performance issues, as the data query of the report happens every time a user interacts with the visualization, which consumes a lot of resources.
Therefore, in addition to using premium capacity to expand resources, it is recommended to use the import connection mode to create reports, and try to access data reports during off-peak hours.
Best Regards,
Community Support Team _ Eason
5 Replies
Hi, JohnHedges
This is usually related to the connection mode of your report.
If you are currently using import mode, data is cached in power bi service and the risk of performance issues is probably very low. If you are using DirectQuery and a large number of users are accessing the report online at the same time, there will inevitably be some performance issues, as the data query of the report happens every time a user interacts with the visualization, which consumes a lot of resources.
Therefore, in addition to using premium capacity to expand resources, it is recommended to use the import connection mode to create reports, and try to access data reports during off-peak hours.
Best Regards,
Community Support Team _ EasonThanks for the response.
At the risk of looking daft, how can I tell what connection mode I'm using?
Thanks 🙂
Hi， JohnHedges
What data source and connection mode are you using when creating reports in Power BI Desktop?
Best Regards,
Community Support Team _ Eason
