Power Query parameter to decide to refresh or not
I would love to have a formula in PQ that decides whether the query needs a full refresh or not. Currently, we can manually select if we want a query to be "included in report refresh". But let's say a huge flat file has not changed since the last refresh - then it's a waste of resource to do a full refresh until it changes. Thanks!
you dont want to use incremental load ? Its supose to do that magic , with only downside that you cant download it back on prem.
No, have you?
José Carlos commented
have you find any solution?