Forum Discussion
Tips on a good process, before adding Workspace to Premium Capacity
Hi , Anonymous
Q1 - Is this WorkSpace business critical or Self-Service BI (SSBI)?
- If business critical
- Please list the datasets/dataflows/datamarts that are business critical?
- DataSet Certified?
**** Tip - Architect your premium capacity to
Separating "business critical" and "Self-Service BI (SSBI)" into different capacities if possible.
Hello, as far as I know, this seems to be a question from a certain department or demand provider for your business situation division work area? If it is convenient, you can distinguish and classify the content in your existing workspace according to business critical/ Self-Service BI and unify them
For "DataSet Certified", as far as I know, this is a function of labeling and certifying the workspace in Power BI. For details, you can check this official document:
Endorsement - Promoting and certifying Power BI content - Power BI | Microsoft LearnQ2 - What premium feature are you intended to use?
- https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-features
According to my experience, the most beneficial features for general Premium users are the large memory in the Premium capacity and the increase in the parallel number of data refreshes, including the maximum storage space of the data model, the improvement of data refresh efficiency and the maximum support time for data refreshes. extension (5 hours) and the maximum supported limit for these given resources also depends on the SKU size of your premium capacity
What is Microsoft Power BI Premium? - Power BI | Microsoft LearnQ3 - Number of users?
- Pro users?
- Users without license?
This question is reflected in my previous reply:In my experience, generally in the workspace where you are assigned Premium capacity, the developer of the report needs to assign a Pro permission, and for the viewer of the report, you do not need to assign them a Pro license, which is also a unique feature of Premium Capacity, and you will follow this principle for specific distribution.
Power BI licensing for users in your organization - Power BI | Microsoft Learn
Q4 - How often will the source be updated?
As far as I know, it depends on your own settings, you can set a scheduled refresh for the dataset (support up to 48 times a day) or trigger the refresh manually (you can achieve unlimited refreshes), you can check this official document:
Data refresh in Power BI - Power BI | Microsoft Learn
Q5 - How often do you need the data to be updated?
This also depends on your needs. For real-time data, you can consider using DQ/LC data connection mode
Q6 - What is the source (DB / Dataflow / Datamart / Files (Type of file) / web)?
Q7 - Number of refreshes per day?
Q8 - How do you refresh your data (Power BI / Powershell / Power automate), scheduled or on demand refresh?
Q9 - What is current refresh time - if more than 10 minutes, have you implemented incremental refresh?
Q10 - Is the WS following our Naming standard?
-- [REGION]–[DATA RELATED TO COUNTRY]–[Sub Business Area]–[WS name if needed]
Q11 - Auto date/time intelligence off?
Q12 - Model, Datasets, dataflows, reports optimized in the workspaces?
- STAR model
# Analyzed with tools like
- Vertipaq analyzer -
- Performance Analyzer -
- Bravo
Q13 - How will you handle access for the workspace, WS/DS/App/Report level? RLS?
Q14 - Number of admins for this WS?
Q15 - Is it only production artifacts in this WS?
- If you need to have dev/test environment.
Tip - Use Deployment pipelines with dev and test WorkSpace in a PPU capacity.
The above questions of serial numbers 5 to 15 seem to be answered by the developers in your tenant according to their own situation. I think these questions are very necessary to be confirmed in advance when releasing or entering the Premium capacity, except In addition, I think another important indicator is how much memory is occupied when data is refreshed, which will have a greater impact on capacity usage and load. You can also mention it in the question.
If you don't have any other questions about this case, you can put some of your and my insights above and reply "Accept as solution", which will make it more convenient for other users with related questions to get quick help! Thanks in advance!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , Anonymous
Q1 - Is this WorkSpace business critical or Self-Service BI (SSBI)?
- If business critical
- Please list the datasets/dataflows/datamarts that are business critical?
- DataSet Certified?
**** Tip - Architect your premium capacity to
Separating "business critical" and "Self-Service BI (SSBI)" into different capacities if possible.
Hello, as far as I know, this seems to be a question from a certain department or demand provider for your business situation division work area? If it is convenient, you can distinguish and classify the content in your existing workspace according to business critical/ Self-Service BI and unify them
For "DataSet Certified", as far as I know, this is a function of labeling and certifying the workspace in Power BI. For details, you can check this official document:
Endorsement - Promoting and certifying Power BI content - Power BI | Microsoft Learn
Q2 - What premium feature are you intended to use?
- https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-features
According to my experience, the most beneficial features for general Premium users are the large memory in the Premium capacity and the increase in the parallel number of data refreshes, including the maximum storage space of the data model, the improvement of data refresh efficiency and the maximum support time for data refreshes. extension (5 hours) and the maximum supported limit for these given resources also depends on the SKU size of your premium capacity
What is Microsoft Power BI Premium? - Power BI | Microsoft Learn
Q3 - Number of users?
- Pro users?
- Users without license?
This question is reflected in my previous reply:
In my experience, generally in the workspace where you are assigned Premium capacity, the developer of the report needs to assign a Pro permission, and for the viewer of the report, you do not need to assign them a Pro license, which is also a unique feature of Premium Capacity, and you will follow this principle for specific distribution.
Power BI licensing for users in your organization - Power BI | Microsoft Learn
Q4 - How often will the source be updated?
As far as I know, it depends on your own settings, you can set a scheduled refresh for the dataset (support up to 48 times a day) or trigger the refresh manually (you can achieve unlimited refreshes), you can check this official document:
Data refresh in Power BI - Power BI | Microsoft Learn
Q5 - How often do you need the data to be updated?
This also depends on your needs. For real-time data, you can consider using DQ/LC data connection mode
Q6 - What is the source (DB / Dataflow / Datamart / Files (Type of file) / web)?
Q7 - Number of refreshes per day?
Q8 - How do you refresh your data (Power BI / Powershell / Power automate), scheduled or on demand refresh?
Q9 - What is current refresh time - if more than 10 minutes, have you implemented incremental refresh?
Q10 - Is the WS following our Naming standard?
-- [REGION]–[DATA RELATED TO COUNTRY]–[Sub Business Area]–[WS name if needed]
Q11 - Auto date/time intelligence off?
Q12 - Model, Datasets, dataflows, reports optimized in the workspaces?
- STAR model
# Analyzed with tools like
- Vertipaq analyzer -
- Performance Analyzer -
- Bravo
Q13 - How will you handle access for the workspace, WS/DS/App/Report level? RLS?
Q14 - Number of admins for this WS?
Q15 - Is it only production artifacts in this WS?
- If you need to have dev/test environment.
Tip - Use Deployment pipelines with dev and test WorkSpace in a PPU capacity.
The above questions of serial numbers 5 to 15 seem to be answered by the developers in your tenant according to their own situation. I think these questions are very necessary to be confirmed in advance when releasing or entering the Premium capacity, except In addition, I think another important indicator is how much memory is occupied when data is refreshed, which will have a greater impact on capacity usage and load. You can also mention it in the question.
If you don't have any other questions about this case, you can put some of your and my insights above and reply "Accept as solution", which will make it more convenient for other users with related questions to get quick help! Thanks in advance!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Regarding your comment " I think another important indicator is how much memory is occupied when data is refreshed, which will have a greater impact on capacity usage and load."
In Gen2, the allocation of the RAM happens per dataset.
Therefore, there will be significantly fewer bottlenecks in the RAM.
I think memory is not a problem in gen2, but please correct me if I'm wrong.
The bottleneck is the computing power (CPU).