Forum Discussion
Performance of shared dataset
Hello,
Has anyone used power BI service shared dataset for a large group of users? Is it slower than each report using its own dataset? We are planning to use multiple reports with live connections to a single power BI service dataset. The largest table in the dataset has about 150k rows. All our users are on pro license. I am wondering if 50 users hit the dataset at the same time through various reports, what will be the performance implications? Any help is greatly appreciated.
Has anyone used power BI service shared dataset for a large group of users? Is it slower than each report using its own dataset? We are planning to use multiple reports with live connections to a single power BI service dataset. The largest table in the dataset has about 150k rows. All our users are on pro license. I am wondering if 50 users hit the dataset at the same time through various reports, what will be the performance implications? Any help is greatly appreciated.
Hi Anonymous ,
You could refer to below link about the CPU resource:
Report queries consume CPU resources in your capacity. Reports with inefficient queries, or many concurrent users, can consume a lot of CPU resources. Your existing capacity may not be sufficient to handle the load.
Regards,
Daniel He
1 Reply
v-danhe-msftMicrosoft Employee
Hi Anonymous ,
You could refer to below link about the CPU resource:
Report queries consume CPU resources in your capacity. Reports with inefficient queries, or many concurrent users, can consume a lot of CPU resources. Your existing capacity may not be sufficient to handle the load.
Regards,
Daniel He