Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Make functions refreshable when the data source is a parameter of the function

    Vote (1232) Share
    Bernd Loigge's profile image

    Bernd Loigge on 14 Aug 2015 03:16:28

    Like discussed here: http://community.powerbi.com/t5/Integrations-with-Files-and/Refreshing-queries-with-functions-doens-t-work/td-p/2450 - queries where data access happens inside a function and where the data source is dependent on parameters to the function should be refreshable.

    Comments (122)
    Bernd Loigge's profile image Profile Picture

    Caio on 05 Jul 2020 23:36:17

    RE: Make functions refreshable when the data source is a parameter of the function

    this is really important

    Bernd Loigge's profile image Profile Picture

    Thomas Krekling on 05 Jul 2020 23:32:43

    RE: Make functions refreshable when the data source is a parameter of the function

    I have a parameter based report, refresh works on it. I have connected the report through my own developed web api. Using a azure app function proxy. The report refreshes nightly after uploading to powerbi cloud

    Bernd Loigge's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 23:32:38

    RE: Make functions refreshable when the data source is a parameter of the function

    For one of our customer we would need this...

    Bernd Loigge's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:28:58

    RE: Make functions refreshable when the data source is a parameter of the function

    yes it gwould be very useful. I'm getting a lot the "You can't schedule refresh for this dataset because" error

    Bernd Loigge's profile image Profile Picture

    Gerard Plante on 05 Jul 2020 23:27:58

    RE: Make functions refreshable when the data source is a parameter of the function

    Any updates here please? Really useful to have to this....

    Bernd Loigge's profile image Profile Picture

    E Young on 05 Jul 2020 23:25:09

    RE: Make functions refreshable when the data source is a parameter of the function

    This is a 3 year old request and still not implemented???

    Bernd Loigge's profile image Profile Picture

    Tom Juntunen on 05 Jul 2020 23:24:48

    RE: Make functions refreshable when the data source is a parameter of the function

    This is a must have function to use parameterization in data source

    Bernd Loigge's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:24:33

    RE: Make functions refreshable when the data source is a parameter of the function

    This is a must have feature. I have multiple reports from APIs with cursor-based pagination in which this is a huge problem.

    Bernd Loigge's profile image Profile Picture

    Alex Korobeinikov on 05 Jul 2020 23:23:43

    RE: Make functions refreshable when the data source is a parameter of the function

    This is a must have function to use parameterization in data source

    Bernd Loigge's profile image Profile Picture

    Danaraj on 05 Jul 2020 23:22:36

    RE: Make functions refreshable when the data source is a parameter of the function

    This is a must have function in order to use parameterization in data source.