Poor Refresh Performance only in Service

Hi,  cassidy 

Based on your description and the tests that have been conducted, I think refresh time delays may occur for the following reasons:
1. Extensive use of dashboard tiles or advanced caching may increase refresh duration, as both operations queue many queries after each refresh.

2. Complex queries and data loading may lead to extended refresh time.

3. Use dynamic data source definitions and costly DAX calculations. In particular, avoid using DAX functions that test every row in the table, as the memory consumption and processing overhead of such functions are very high.

4. Resource limitations. In Power BI Service, data refresh resources may be limited based on system load. If your semantic model is refreshed during periods of high system load, you may experience reduced frequency.

You can follow the following points to troubleshoot and improve the refresh performance of your semantic model:

Related document links: Data refresh in Power BI - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.