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

    1620cae3 4093-4ccd-b2f6-29276ff9bffc on 06 Jul 2020 00:06:38

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

    let's go

    Bernd Loigge's profile image Profile Picture

    26dd09ed 845d-4303-a914-ddd62bcb5b14 on 06 Jul 2020 00:02:38

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

    Please let us know this is on the roadmap!
    Ray

    Bernd Loigge's profile image Profile Picture

    1a1ed64a f728-4787-8068-0d5ffb4b6d67 on 06 Jul 2020 00:02:18

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

    This has been asked over 4 years ago. It's a severe gap not to have it.

    Bernd Loigge's profile image Profile Picture

    011395e5 9bd4-4ea7-a4ca-d92627a2c6ad on 05 Jul 2020 23:59:29

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

    This would be a much appreciated feature, please do add this functionality.

    Bernd Loigge's profile image Profile Picture

    946d1262 2246-4973-a894-99587a304ee7 on 05 Jul 2020 23:58:17

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

    Can u please add this feature? I have a great report which contains lots of parameters as functions for odata, without web service refresh power bi is not useful.

    Bernd Loigge's profile image Profile Picture

    f7ccb467 7445-467f-9f3d-ee1725a70db0 on 05 Jul 2020 23:56:26

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

    seems this idea posted on Aug 14th 2015, it is exactly 4 years for today. how many votes required to add this functionality any idea to any one?

    Bernd Loigge's profile image Profile Picture

    a40263ba 7db8-4b7e-9046-7450e50a1e5f on 05 Jul 2020 23:56:09

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

    Please add this functionality

    Bernd Loigge's profile image Profile Picture

    abcb8850 375d-442a-8502-080835cdcff9 on 05 Jul 2020 23:55:45

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

    Any Update?

    Bernd Loigge's profile image Profile Picture

    4f859e08 41f7-443f-8ff7-cd21fe48e8e2 on 05 Jul 2020 23:54:47

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

    Allow the user to choose, from a parameter drop down a server they ewant to look at. The parameter either populated from a list or query, and the datasource changed accordingly, (the last bit I can do).

    It would be great to add this feature, you cannot really allow users access to the desktop versin, you want them to use the server versin, but it is really tough if you cannot use a parameter to drive what the user sees.

    Bernd Loigge's profile image Profile Picture

    63c3ac17 e806-46bd-82b9-483d26f6a8a9 on 05 Jul 2020 23:51:40

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

    I had to take my code out of the function and into the body of Power Query code itself. Kind of messy. Would like to use functions.