Forum Discussion
Help! Slow PBI Service Loading GCC
- 1 year ago
Thanks! ended up using a dataflow to capture the sharepoint file data and it seems to be performing better!
Hi jb217
Since Thursday, May 29, 2025, you've observed a significant performance degradation across the entire Power BI environment in your GCC (Government Community Cloud) client tenant, where reports, workspace apps, and visuals are taking several minutes to load instead of the usual seconds. This widespread slowdown is affecting multiple workspaces and report objects, raising concerns that recent development changes might be contributing to the issue. Specifically, on the same day the issue began, your team added a small Excel file (with only about 20 rows) hosted on a SharePoint folder as a data source to several semantic models, and also scheduled those models to refresh every three hours. While it's true that SharePoint can be slower compared to other data sources, the size of your file is minimal, and it wouldn’t reasonably explain degraded performance across unrelated workspaces and reports. However, if these refreshes are running frequently and in parallel—especially in a Premium or Fabric capacity environment with shared compute resources—it’s possible they’re consuming a disproportionate share of the capacity's memory or CPU, which could lead to throttling and affect overall performance. Since you're not yet a Fabric admin, gaining access to tools like the Capacity Metrics App or Fabric Admin Monitoring workspace would be helpful. These tools can provide visibility into memory usage, refresh queues, and query wait times to determine whether the tenant is being bottlenecked by too many concurrent operations or inefficient model configurations. It’s important to rule out broader service-side issues as well, especially in GCC environments, by checking the Microsoft 365 Service Health Dashboard for any reported incidents affecting Power BI.