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...
Need Help
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.  

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

        selimovd 

         

        The merged table actually does not have any relationships with any other table so "Assume Referential Integrity" is not checked.  Should it have a relationship with the two tables that the data is from?