Skip to main content

    Power BI

    Needs Votes

    Power Query parameter to decide to refresh or not

    Vote (34) Share
    Kristof's profile image

    Kristof on 16 Dec 2019 19:14:41

    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!

    Comments (3)
    Kristof's profile image Profile Picture

    Brank on 06 Jul 2020 00:11:29

    RE: Power Query parameter to decide to refresh or not

    you dont want to use incremental load ? Its supose to do that magic , with only downside that you cant download it back on prem.

    Kristof's profile image Profile Picture

    Kristof on 06 Jul 2020 00:05:21

    RE: Power Query parameter to decide to refresh or not

    No, have you?

    Kristof's profile image Profile Picture

    José Carlos on 06 Jul 2020 00:05:18

    RE: Power Query parameter to decide to refresh or not

    have you find any solution?