Forum Discussion

MSUSPARTAN's avatar
MSUSPARTAN
Frequent Visitor
4 years ago
Solved

Issue with refreshing a table based on data from another table

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 tabl...
Need Help
  • MSUSPARTAN's avatar
    MSUSPARTAN
    4 years ago

    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.

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

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's avatar
MSUSPARTAN
Frequent Visitor
4 years ago

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.