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

    d13118c1 1a55-4f27-b687-665be9f60d32 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

    b3a8c3a2 2cbc-42ff-b645-9f104abfcd7c 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

    f6df0738 e45c-4c6f-abd8-85e838faa3f0 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

    25fe867e 394a-45ac-9a77-0b553921e7ad 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

    33ff03fe 0fc8-4f55-a439-95e02ef29f27 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

    37a0e18f 5f77-4996-b03a-cbad859ee297 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

    7fe1753f fd7c-418b-ab3e-324f77c5b767 on 05 Jul 2020 23:46:24

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

    PLEASE!!!!!

    Bernd Loigge's profile image Profile Picture

    89ed1111 83c7-43cb-a979-8eda99781772 on 05 Jul 2020 23:46:18

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

    Any updates on this? Having M work in desktop but not in the service is a real headache; getting this fixed would really help with keeping report development/publishing a more seamless process.

    Bernd Loigge's profile image Profile Picture

    90ffc094 e150-46af-91af-a426e4a5c67e on 05 Jul 2020 23:43:10

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

    This thread is three and a half years old...are there any plans to implement this? Not offering this functionality in the online refresh is essentially punishing users for trying to keep their queries and M code neat and organized with functions.

    Bernd Loigge's profile image Profile Picture

    80563a9a 00a4-40b8-ac9c-b20f9d2ddf29 on 05 Jul 2020 23:40:49

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

    Just published a report that used this functionality...only to find it isn't there. Hope you guys can make this work at some point.