Forum Discussion

vanessafvg's avatar
vanessafvg
Community 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
    Helper 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"