Forum Discussion

nataliesmiy1357's avatar
nataliesmiy1357
Helper 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 Enable Load nad Include in report refresh - but my data isn't in there.

 

What am I missing?

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

5 Replies

  • Daniel29195's avatar
    Daniel29195
    Community Champion
    2 years ago

    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! 🤠

  • 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"

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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