Issue with refreshing a table based on data from another table

[MSUSPARTAN]

I have a sql view that I've pulled into powerBI (Table 1).  I have added a few columns to table 1.  I have created a second table(table 2) using power query that summarizes some of the data from table 1.  I am then using the summarized table #2 and using it for a lookupvalue in anther table (table #3).

As I make changes to table #1 data (refreshing the data set, changing formulas, etc) table #2 is not updating.  I need all the tables to update automatically on refresh.

Please help

[MSUSPARTAN · Accepted solution]

Thought I'd follow up on this.  I've been able to fix the issue.  The tables were updating correctly all the long.  I had some filtering that I didn't set up correctly that was causing the issue and making it seem like they weren't updating.  Thanks for the help and the time everybody.

[MSUSPARTAN]

To clarify my calculated tables are not refreshing when the tables they are based are changed or refreshed

[Anonymous]

What's up with your Asphalt table. If that is used by Commitment Summary, then you need to fix Asphalt. 

--Nate

[MSUSPARTAN]

Nate-  appreciate the help.  The asphalt table isnt used.  (I've deleted it from my model now)

[Anonymous]

I bet that with lazy evaluation, if Table 2 is set to Do Not Load, then Table2 won't refresh until Table 3 (if set to Load) needs something from Table 2.

That's a guess, but I am certain that if you set all 3 tables to Load, they will all refresh.

--Nate 

[Vijay_A_Verma]

Are you refreshing a single table or entire data model? If you refresh from Home menu - Refresh - This would refresh all tables. Right clicking on a table -Refesh data will refresh only a single table.

Auto refresh in other table happens when the other table is a reference table. Then original table refresh will refresh reference table as well.

[MSUSPARTAN]

Thanks for the help.  I'm refreshing the entire model.  I also dont seem to have the option to edit.  I attached a screen shot. Commitment summary is one of the summary tables that arent refreshing properly.