Forum Discussion
Solved
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 upda...
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?
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.