Merge Updating with Refresh

[nataliesmiy1357]

Hello - I have two tables (Downtime and OR) and they are merged together with a key identifier.

I just refreshed both tables, but my merge didn't update with the most recent data.

I have the Enable Load nad Include in report refresh - but my data isn't in there.

What am I missing?

[Anonymous]

Hi @nataliesmiy1357 ,
Based on your description, you can check the following areas to see if they are the cause of the unsuccessful refresh.
First, revisit the merge operation in the Power Query Editor to ensure that the key identifier for the merge is set correctly and that there is no mismatch in data types between the key columns in the Downtime and OR tables. Data type mismatches can sometimes cause unexpected problems with merge operations. Second, make sure that merged queries are not inadvertently excluded from report refreshes.

Best regards,

Albert He

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

[vanessafvg]

when you say it didn't merge was that in power query or the front end of power bi?  if you use refresh preview in power query does it update?

how do you know it hasn't updated?  where are you updating from?

can you post your power query code from the advanced editor?

[nataliesmiy1357]

I have refreshed it IN Power Query, and outside of Power Query - I still cannot see my data from January 2024.

This is my Advanced Editor code:

let
Source = Table.NestedJoin(#"Downtime Report", {"Date and Plant"}, #"OR Report", {"Date and Plant"}, "OR Report", JoinKind.FullOuter),
#"Expanded OR Report" = Table.ExpandTableColumn(Source, "OR Report", {"Planned OR%", "Line Result", "Date and Plant"}, {"OR Report.Planned OR%", "OR Report.Line Result", "OR Report.Date and Plant"})
in
#"Expanded OR Report"

[Daniel29195]

@nataliesmiy1357 

did you try refreshing from outside the power query ? 

cause the refresh on power query doesnt affect the data outside of power query. 

you need to refresh the data from here .

let me know if this works. 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[nataliesmiy1357]

I just pressed the refresh button and it still did not work 😕