Forum Discussion
How to update just some tables
Hello all...
Is it possible to update just some tables in Power BI?
I need to regularly update 3 different tables, but I have like 30 tables in total in my Desktop Power BI.
I'd like to update just these 3 tables in one step.
Thanks in advance
To the best of my knowledge, I'm not aware of a way to do what you are asking. I'm thinking that maybe you could get there using a query parameter that each query would check, but I don't think that you could just "exit" the query and not do data refresh. ImkeF, any magic?
7 Replies
there are 2 ways:
1. Automatic: Go to Power Query Editor, right click on each table you don't want to refresh and untick "Include in refresh". That'll exclude these tables from the global refreshing unless you return that tick above.
2. Manual: Go to Model view, choose the tables you want to refresh with CTRL/Shift, right click and refresh. You can do the same in the report view, however, using CTRL/shift is disabled there.
- Greg_Deckler
Community Champion
Right-click your queries in Query Editor and uncheck data refresh.
Ok.
But I don't see how to select a group of tables I want to refresh to then refresh them all together (not having to select and refresh one, then the other, then the other...)
- Greg_Deckler
To the best of my knowledge, I'm not aware of a way to do what you are asking. I'm thinking that maybe you could get there using a query parameter that each query would check, but I don't think that you could just "exit" the query and not do data refresh. ImkeF, any magic?
