Forum Discussion
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 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
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.
7 Replies
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.
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.
Nate- appreciate the help. The asphalt table isnt used. (I've deleted it from my model now)
To clarify my calculated tables are not refreshing when the tables they are based are changed or refreshed
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.
