Skip to main content

    Power BI

    New

    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

    5d9a4269 5dad-42f9-a0fa-8c74a0d4ccc4 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

    c9abcedf 1b41-4254-9266-85a82d3e19f2 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

    d8ce7c01 db4d-4863-b6f5-faab1fb40ec7 on 06 Jul 2020 00:05:18

    RE: Power Query parameter to decide to refresh or not

    have you find any solution?