Forum Discussion
How to update just some tables
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?
Community ChampionRight-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?
- 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-in/idi-p/331982#M19945 )
Thanks for your supportGreg_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
