Challenges you have faced during Power BI report development

[Subscriber]

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

[Anonymous · Accepted solution]

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：

Value from previous row – Power Query, M language – Trainings, consultancy, tutorials (exceltown.com...

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.