Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

Reply
nanr
New Member

Semantic Model - Refresh Issues

Hi team,


Has anyone been experiencing issues with semantic model refreshes recently?
I'm seeing some odd behavior where either I get a "field not found" error, or the refresh completes without errors but data from a staging Power Query table isn't flowing into another M query merged table that combines that staging table with other data


I've refreshed the semantic model multiple times since yesterday and the data still isn't making it through the merged query, even after validating that there are no filters or transformation logic that should be preventing it from reaching the final table


I'm wondering if this could be related to something new with Fabric refresh behavior, such as tables refreshing in parallel without fully respecting dependencies. Has anyone run into something similar? Also, is there a way to explicitly define refresh dependencies between tables or queries to prevent this kind of issue? Thankss

5 REPLIES 5
v-sathmakuri
Community Support
Community Support

Hi @nanr ,

 

Could you please check the provided solution and let us know if you have any further questions.

 

Thanks!!

v-sathmakuri
Community Support
Community Support

Thank you @PauReis  and @GilbertQ  for the prompt response.

 

Hi @nanr ,

 

Thank you for reaching out to fabric community.

 

Could you please review the suggestions provided above and let us know if you have any further questions.

 

Thanks!!

GilbertQ
Super User
Super User

Hi @nanr 

 

What I can recommend is to make sure you have downloaded the latest version of Power BI desktop. Then open up your semantic model. Refresh it first there to make sure everything is working as expected. Once that is done, we upload it to the Power BI service and see if that resolves your issue.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Thanks for replying, yes I did try to refresh it locally, but unfortunately the merged m query is not able to complete a refresh on desktop, however it showed me more loading rows than the ones that were there already

That last detail you added is the important one, more than the "field not found" was: more rows loading than were there to begin with. That's not a refresh ordering problem, that's the merge, and it explains why it never finishes.

 

A merge is a join. If the key you're matching on isn't unique in the right-hand table, every row on the left comes back once per match, so two duplicates on the right doubles it, three triples it, and the row counter runs off past your source count. Nothing errors, it just grows, which is why it presents as a refresh that hangs rather than one that fails.

 

Two minutes to confirm it: take the right-hand query, Group By on the join key with a Count, then filter to Count greater than 1. Or just Keep Duplicates on that column. If anything at all comes back, that's your cause. The fix is to get the right side down to one row per key before the merge, with a Group By or Remove Duplicates on the key. And if the multiplication is actually intended, use the aggregate option in the expand step instead of expanding to rows.

 

Worth checking the key's data type on both sides at the same time, because that's the other half of what you're describing. Microsoft's own note on merging is that the columns have to be the same data type or the merge "might not yield correct results", and a type mismatch gives you the opposite symptom, no matches and nulls, which reads exactly like data not flowing through to the final table.

 

On the parallel refresh theory, I'd let that one go. Referencing doesn't work the way it looks like it does. There isn't a staging result that gets computed once and handed to the queries that reference it. From the guidance page: "it's often assumed that Power Query retrieves the Query1 result, and that it's reused by referenced queries. This thinking is incorrect." What actually happens is the staging steps get inlined into each query that references it and run again from scratch, and in the service it's stricter still, since each query refreshes using its own separate cache.

 

So there's no ordering to get wrong and no dependency setting to reach for, because the dependency you're picturing isn't there. Don't try to fix it with Table.Buffer either, the same page is explicit that a buffer only survives within a single query execution and that doing this can make it worse rather than better. If you genuinely want that staging table materialised once and read cheaply by everything downstream, that's a dataflow, which is what Microsoft recommends for exactly this shape.

 

I'd treat "field not found" as its own thing rather than a symptom of the same problem. That one usually means a column got renamed or dropped upstream and a later step is still asking for it by name.

 

How many rows does the right-hand query return, and is that key actually unique in it?

 

https://learn.microsoft.com/en-us/power-bi/guidance/power-query-referenced-queries

 

https://learn.microsoft.com/en-us/power-query/merge-queries-overview

Helpful resources

Announcements
Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Kudoed Authors