power bi 容量限制

Dear @HsiehMardy,

Thank you for reaching out to Microsoft Q&A forum.

I understand that you're experiencing issues with Power BI. Based on your description, the message “Capacity operation failed with error code CapacityLimitExceeded”, along with being unable to use the Power BI service or publish .pbix files, typically indicates that your organization’s Microsoft Fabric capacity (which powers Power BI Premium features) is overloaded or has exceeded its available compute resources (primarily CPU and memory) at the time of the operation.

From my research, this is a common issue in Power BI Premium, Premium Per User (PPU), or Fabric capacities when demand suddenly spikes, for example, due to large dataset refreshes, multiple users accessing or refreshing reports at the same time, complex queries, or background operations consuming too many resources. When this happens, the capacity becomes throttled, and Power BI temporarily blocks interactive actions such as opening reports, refreshing datasets, or publishing PBIX files. It’s usually not a permanent block, but rather a temporary response to overload.

As a forum moderator, I genuinely wish I could directly access your environment or diagnose backend systems for you. However, our role here is limited to providing general guidance and user‑actionable solutions. Also, I noticed you are using both Chinese and English in your post, feel free to let me know which language you are more comfortable with so I can respond accordingly.

Please try the following steps to resolve this issue:

1.Wait and Retry

Capacity overloads are often temporary, especially during peak usage times. Waiting 15–60 minutes (or longer in heavy-load scenarios) and then trying again often resolves the issue automatically.

2.Monitor Your Capacity Usage (Most Important Step)

Install and use the Microsoft Fabric Capacity Metrics app, this is the official way to diagnose overloads.

• It shows CPU/memory usage over time, which workloads/items cause spikes, throttling events, and overload timestamps.
• Install it in a Pro-licensed workspace (not a Fabric/capacity workspace, to avoid access issues during throttling).
• Look at the Compute page for system events and overload indicators.

For references: 

Install the Microsoft Fabric Capacity Metrics app

Troubleshooting guide - Diagnose and resolve "capacity limit exceeded" errors - Microsoft

3.Check and Optimize Workspaces/Items 

To prevent future overload:

• Identify high-resource reports/datasets (e.g., large models, frequent refreshes, DirectQuery with heavy queries).
• Move non-essential items to shared/Pro workspaces if possible (shared capacity has its own limits but won't affect your paid capacity).
• Reduce data volume (remove unused columns/tables)
• Use aggregations when possible
• Schedule refreshes during off‑peak hours.

4.Scale Up or Adjust Capacity

If overloads happen frequently:

• Upgrade to a larger Fabric SKU via the admin portal or your Microsoft account.
• Enable autoscale (if available on your SKU) to temporarily add resources during peaks.
• For Premium capacities: Check admin portal > Capacity settings > Workloads to adjust memory allocation for semantic models.

References: 

Capacities and SKUs in Microsoft Fabric  

What is Power BI Premium?

Additionally, because this forum primarily focuses on Office 365 products and their native features, we have limited resources and very little insight into Power BI–specific scenarios. This issue is better supported by specialists in the Power BI forums at the Power BI forums - Microsoft Fabric Community 

I hope this information is helpful and provides you with a clear path forward. Please follow these steps and let me know if they work for you. Thank you for your patience and understanding. If you have any questions or need further assistance, feel free to share them in the comments so I can continue to support you. I look forward to your reply.

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.