How to update just some tables

[ADC]

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

[Mabuse1]

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]

Right-click your queries in Query Editor and uncheck data refresh.

[ADC]

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 · Accepted solution]

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?

[ImkeF]

No further idea from me here.

Incremental load is planned for the Premium-version (and unchecking data-load only works if you haven't referenced the "not-to-load-queries" anywhere in subsequent queries btw. It will also be ignored in the service: https://community.powerbi.com/t5/Issues/quot-Include-in-report-refresh-quot-disabling-doesn-t-work-i... )

[ADC]

Thanks for your support@Greg_Deckler and @ImkeF

Then I'll manage with a selection of the tables I want to update with the option "Include in report refresh" in the Query Editor I think...

Regards

[Greg_Deckler]

Sorry @ADC, sometimes there isn't an answer. You might think about adding this to Ideas if it isn't out there already. Would be pretty handy I think.