Skip to main content
Microsoft Idea

    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?