Forum Discussion
Max Concurrent Pages
Hi crobinson661
In terms of concurrency, if you have a lot of users all using the same report, Power BI caches the results, so when a report is rendered using the cache it gets that straight from memory and does not require any CPU. It is only when running DAX queries that need to get the data from the model that it will then need CPU.
If you design your data with a star schema (facts and dimensions), that means that your DAX measures will be easy to be calculated and will not require much CPU, which means not a very high demand on the CPU.
With the above of best practice design a single report or multiple reports can scale to many users because they all share the cache and also when need a new DAX measure it will not require a lot of CPU. So it depends on how your dataset is modelled and how efficiently the DAX measures are created.
Hi crobinson661
In terms of concurrency, if you have a lot of users all using the same report, Power BI caches the results, so when a report is rendered using the cache it gets that straight from memory and does not require any CPU. It is only when running DAX queries that need to get the data from the model that it will then need CPU.
If you design your data with a star schema (facts and dimensions), that means that your DAX measures will be easy to be calculated and will not require much CPU, which means not a very high demand on the CPU.
With the above of best practice design a single report or multiple reports can scale to many users because they all share the cache and also when need a new DAX measure it will not require a lot of CPU. So it depends on how your dataset is modelled and how efficiently the DAX measures are created.