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
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?

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

    v-kelly-msft 

    Yes i tried that.  If I need to get data by first doing a search in one table first via the summarize function in a measure, then using the result of that to get data from a second table.  Would it be faster if I do it like this or would it be faster to join these two tables and only load it to memory once?  BUt i noticed when joining columns from two seperate tables, it takes time to do the join i suppose?