Weird Semantic Model Refresh Issue

Hi id013 ，

Thank you SaiTejaTalasila  very much for the solution, I have some other thoughts on the subject:

Thank you for your detailed description of the problem encountered. Based on your description, the issue may be related to Power Query's Query Folding and caching mechanism:
Query Folding is an important optimization mechanism in Power Query that pushes the data transformation step back to the source system so that the query can be executed using the computational power of the source system. This can significantly improve query performance, especially when working with large amounts of data.
Checking Query Folding Status
In the Power Query editor, right-click on a query step to see if the “View Native Query” option is available.
Make sure that as many steps as possible can be collapsed. For example, simple actions such as filtering and selecting columns can often be collapsed. Here are some suggestions that can help optimize query folding:
1. Use simple steps: Prioritize steps that can be collapsed, such as filtering, selecting columns, and sorting.
2. Avoid complex calculations: Try to avoid complex calculations in Power Query and instead push these calculations to the source system.
Understanding query evaluation and query folding in Power Query - Power Query | Microsoft Learn
Caching Issues
Power Query uses caching to improve performance when previewing data, but sometimes caching can lead to inconsistent behavior; clearing the cache can help troubleshoot this issue.
Use storage mode in Power BI Desktop - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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