Forum Discussion

nataliesmiy1357's avatar
nataliesmiy1357
Icon for Helper IV rankHelper IV
2 years ago

Merge Updating with Refresh

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 ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
2 years ago

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's avatar
nataliesmiy1357
Icon for Helper IV rankHelper IV
2 years ago

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"