Forum Discussion

wpf_'s avatar
wpf_
Icon for Post Prodigy rankPost Prodigy
5 years ago

How to get merged table data to refresh?

I merged two tabes using a left outter join in power query.  Now when i update data in the data source, and update a measure, the table visual refreshes but does not show the new data.  I had to do a data refresh in order to see it.  Normally I do not need to do a data refresh.  Then when i upload it to bi service, a visual refresh does not show the new data, only a data refresh would show it.  Again normally a visual refresh would do the trick.  How can i get the merged table to get the new data without doing a data refresh?  I have 'enable load' and 'include in report refresh' checked for the table.  Thanks 

Need Help

6 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Hey wpf_ ,

     

    how did you connect to the data source? Is it import or direct query mode?

    If you imported the data in import mode you always need to click the "Refresh" button or schedule a refresh that the data is being refreshed.

     

    The behavior that the data refreshes when you change something in a visual is common for direct query. But if you're in import mode the visuals work on the imported data set.

    You can change the import mode from import to direct query, but aware of the disadvantages of DQ:

    Power BI Switch From Import To Direct Query Mode (devoworx.com)

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • wpf_'s avatar
      wpf_
      Icon for Post Prodigy rankPost Prodigy
      5 years ago

      selimovd 

       

      Thanks for your reply.  I am using directquery.  I thought maybe merged tables behave differently?  Could it be that the last two steps of my query could not be folded?  The last two steps are getting the last 3 char of a column, and trimming a column.  The join instruction is folding though.