DevOps Analytics View using up tons of resources in PBI services

[DSCLiden]

Hi,

We have a Power BI report which connects to two different DevOps projects using the Analytics View connector (Source = VSTS.AnalyticsViews). The report is about 1,5Mb in size. 

When refreshing the dataset in desktop is takes about 1h. "Initializing" and "Waiting" takes up about 50% of the time.

When refreshing in Services (P3 environment) it takes about 1h 40m to refresh. We have now turned off the schuduled refresh since this dataset takes up way too much of the premium capacity. 

Please advince on what to do here. I'm really confused why this is refreshing so incredibly slow and takes up so much resources just to load about 10k rows in total. 

[Anonymous]

Hi @DSCLiden ,

Here are some suggestions that might help improve the performance:

1.Optimize Data Model: Ensure your data is modeled properly. Avoid using complex logical operations and building a star schema can help improve performance.

2.Incremental Refresh: Consider using an incremental refresh. This feature only refreshes the data that has changed instead of the entire dataset.

3.Use Dataflows: Dataflows can help improve performance by offloading the ETL workload from the dataset refresh process.

4.Performance Analyzer in Power BI Desktop: Use the Performance Analyzer in Power BI Desktop to identify which elements of your report, such as visuals and DAX formulas, are causing performance issues.

5.Optimize Gateway Performance: If your data source is remote and there’s slow network communication, optimizing the on-premises data gateway performance might help.

6.Upgrade to Latest Version: Ensure that your gateway version is up to date.

7.Check Capacity: If your report is hosted on a Premium capacity, use the Microsoft Fabric Capacity Metrics app to determine if the report-hosting capacity frequently exceeds capacity resources.

Remember, the performance of a Power BI report depends on various factors including the complexity of the report, the size of the data, and the capacity of the Power BI service. It’s important to monitor and optimize these factors regularly to ensure optimal performance.

Best regards,
Community Support Team_ Scott Chang