Hi @AndreaLee1212
There are several factors that can determine whether a company should choose Power BI Premium P1 or P2. One key factor is the number of users that will be accessing the reports and dashboards. P1 is designed for small to medium-sized teams with a maximum of 8 concurrent users, while P2 is designed for larger teams with a maximum of 20 concurrent users.
Another important factor is the complexity and size of the data models. P1 is suitable for smaller data models with less complex queries, while P2 is designed for larger and more complex data models with more demanding queries. P2 also offers more advanced features such as row-level security and dataflow management.
Another factor to consider is the refresh rate and data freshness. P1 allows for 8 refreshes per day and P2 allows for 48 refreshes per day, so if your data needs to be updated frequently, P2 would be the better option.
In terms of cores, the number of cores needed will depend on the number of users and the complexity of the data models. As a general rule, the more users and the more complex the data models, the more cores will be needed. However, it's important to note that Microsoft does not provide specific guidelines on the number of cores needed for P1 and P2. It is generally recommended to start with a smaller number of cores and scale up as needed.
It's also important to note that load testing is a good way to determine the number of cores needed for your specific use case. By simulating the expected usage patterns and monitoring the performance, you can get a better idea of the resources needed to support your workloads.
