Skip to main content

    Power BI

    Needs Votes

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

    Vote (1047) 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 (117)
    Bernd Loigge's profile image Profile Picture

    760e8571 d1f0-445a-a8b4-624af0993e57 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

    5ac4c302 bbd8-4520-85a9-c15072cc23ec 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

    0ca7c18a 834e-4f62-8fd5-e1477344f9c9 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

    94e72eb0 5abf-4dff-9fea-76d88a1d75ac 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

    a7babe40 b169-4ce3-aaa2-71f3e3e58fd1 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.

    Bernd Loigge's profile image Profile Picture

    6d304b81 74fe-454b-80d7-f9cc920acd8b on 05 Jul 2020 23:21:00

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

    Just realized this is an issue and really hampers the ability to use any type of Power Bi Template with parameters in it.

    Bernd Loigge's profile image Profile Picture

    d7868583 eec6-441e-885b-07d7698dd86e on 05 Jul 2020 23:20:26

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

    Hows this going? any progress especially an issue with all the API data out there

    Bernd Loigge's profile image Profile Picture

    0c92b622 b9a7-42f8-b3cf-b6a78e490d09 on 05 Jul 2020 23:18:26

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

    I expected this to be a basic requirement, but surprised that it's not there, Please add this

    Thank you very much !

    Bernd Loigge's profile image Profile Picture

    81ce4dee 9a3a-4f38-98cd-2bc49c0c5fa2 on 05 Jul 2020 23:18:24

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

    Serious functionality problem here. At least provide us feedback at the construction phase of reporting. Painful when you realise a new solution needs to be generated to resolve this 'bug'

    Bernd Loigge's profile image Profile Picture

    dd163cb8 20de-46be-ac82-3727c19d1b62 on 05 Jul 2020 23:17:43

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

    Adding this feature would be awesome! Please get it on the list.