Skip to main content

    Power BI

    Needs Votes

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

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

    Giovanni Miraglia 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

    Jeff Westcott 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

    Neil Stewart 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.

    Bernd Loigge's profile image Profile Picture

    FD on 05 Jul 2020 23:51:32

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

    Need This Feature ASAP..

    Bernd Loigge's profile image Profile Picture

    M.Rux on 05 Jul 2020 23:51:07

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

    I Need this too, asap

    I dont understand how other users can work without this feature, when tables have Millions of entries and only one day/month/year is important...

    Why is it so difficult, to give a User-Prompt for Parameters, when need

    Bernd Loigge's profile image Profile Picture

    Joey on 05 Jul 2020 23:50:00

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

    Any update here? Potential workarounds for parameterized ODBC DSNs?

    Bernd Loigge's profile image Profile Picture

    Heath on 05 Jul 2020 23:49:25

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

    Need this!

    Bernd Loigge's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:48:38

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

    Pleaseeee add this Power BI team. I have a list of parameters that my team keeps updated in Google Sheets as that is their preferred method, but I can't refresh pulling from this external source. Need this data to make my API calls in Power BI.

    Bernd Loigge's profile image Profile Picture

    Michael Colbert on 05 Jul 2020 23:47:13

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

    Just a thought, I wonder if DataFlows would get around this limitation? But is oData supported in DataFlows just yet?

    Bernd Loigge's profile image Profile Picture

    T Justin Allen on 05 Jul 2020 23:46:24

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

    PLEASE!!!!!