Forum Discussion
Challenges you have faced during Power BI report development
Hi Team,
Please post the 4 or 5 challenges you have faced during Power BI project development.
Please let us know how you did overcome them.
Challenges could be at Power Query, Power BI desktop, and Power BI Services
and How many Reports can we create in 4-5 years of time?
Please Share your valuable information.
Thanks in Advance
Hi Subscriber ,
For your needs, I found related problems in various forums, and solutions, you can check the following LINK:
Power BI Desktop：
Solved: Matrix column header/label custom group - Microsoft Power BI Community
Solved: Total not Matching - Microsoft Power BI Community
How to put the row and column subtotals in front o... - Microsoft Power BI Community
Power BI Service：
Solved: Schedule Refresh Failed - Microsoft Power BI Community
Solved: Scheduled refresh has been disabled. - Microsoft Power BI Community
Troubleshooting refresh scenarios - Power BI | Microsoft Learn
Power Query：
Solved: DataSource.Error when connecting to ADO.NET provid... - Microsoft Power BI Community
Solved: Assign attributes randomly - Microsoft Power BI Community
For the number of reports, as far as I know, there is no limit to the number of reports you can store and publish on the Power BI service, but the size of storage that can be placed in the workspace for reports and datasets and the total size of storage that can be published for an account is determined by your Power BI subscription license and capacity.
For workspaces in shared capacity:
- There's a per-workspace storage limit of 10 GB.
- Premium Per User (PPU) tenants have a 100-TB storage limit.
- When you're using a Pro license, the total usage can’t exceed the tenant storage limit of 10 GB multiplied by the number of Pro licenses in the tenant.
For workspaces in Premium capacity:
There's a limit of 100 TB per Premium capacity.
There's no per-user storage limit.
Workspace storage usage is shown as 0 (as shown in this screenshot) if the workspace is assigned to a Premium capacity.
For more detailed information about the restrictions, you can check this official document:
Manage data storage in your workspaces - Power BI | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Subscriber ,
For your needs, I found related problems in various forums, and solutions, you can check the following LINK:
Power BI Desktop：
Solved: Matrix column header/label custom group - Microsoft Power BI Community
Solved: Total not Matching - Microsoft Power BI Community
How to put the row and column subtotals in front o... - Microsoft Power BI Community
Power BI Service：
Solved: Schedule Refresh Failed - Microsoft Power BI Community
Solved: Scheduled refresh has been disabled. - Microsoft Power BI Community
Troubleshooting refresh scenarios - Power BI | Microsoft Learn
Power Query：
Solved: DataSource.Error when connecting to ADO.NET provid... - Microsoft Power BI Community
Solved: Assign attributes randomly - Microsoft Power BI Community
For the number of reports, as far as I know, there is no limit to the number of reports you can store and publish on the Power BI service, but the size of storage that can be placed in the workspace for reports and datasets and the total size of storage that can be published for an account is determined by your Power BI subscription license and capacity.
For workspaces in shared capacity:
- There's a per-workspace storage limit of 10 GB.
- Premium Per User (PPU) tenants have a 100-TB storage limit.
- When you're using a Pro license, the total usage can’t exceed the tenant storage limit of 10 GB multiplied by the number of Pro licenses in the tenant.
For workspaces in Premium capacity:
There's a limit of 100 TB per Premium capacity.
There's no per-user storage limit.
Workspace storage usage is shown as 0 (as shown in this screenshot) if the workspace is assigned to a Premium capacity.
For more detailed information about the restrictions, you can check this official document:
Manage data storage in your workspaces - Power BI | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.