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

    adb2e852 9493-4cf0-a97a-c49d6a0d0645 on 05 Jul 2020 23:17:12

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

    I am facing the same issue. I have 10-15 reports which were working fine before couple of weeks and all were using function but it stopped refreshing suddenly and now I am in deep trouble.
    How this can be resolved quickly ?

    Bernd Loigge's profile image Profile Picture

    26ebfb0e 0a9d-4267-a2e0-b3510df9f9e1 on 05 Jul 2020 23:17:08

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

    How many votes are needed to implement this functionality. I have created several workarounds to overcome this hurdle, but since last month, the scheduled refresh on queries with custom functions and parameters has stopped working.

    Bernd Loigge's profile image Profile Picture

    c618ecd9 1ac0-48af-b8b6-0f192cd243fb on 05 Jul 2020 23:16:56

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

    Just spent 3 hours solving a function / M challenge - to find out that PBI.Com can't run functions. Nice. (Grrrr)

    Bernd Loigge's profile image Profile Picture

    9aba1e54 d440-40fc-b37e-0d3a182acd40 on 05 Jul 2020 23:15:39

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

    https://social.technet.microsoft.com/Forums/en-US/208b9365-91e9-4802-b737-de00bf027e2a/alternative-calling-function-with-text-string?forum=powerquery

    Bernd Loigge's profile image Profile Picture

    3b983085 9e33-445b-9838-e2ce718471c0 on 05 Jul 2020 23:14:25

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

    I don't understand why this is a problem. So, hope to get it solved soon

    Bernd Loigge's profile image Profile Picture

    7b1d8147 5cb6-4399-8bde-f88589145670 on 05 Jul 2020 23:13:35

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

    Any update on this idea ? Really needed

    Bernd Loigge's profile image Profile Picture

    e06d6fa6 cf20-4f4b-a605-1b02d51e4423 on 05 Jul 2020 23:12:53

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

    Why MS don;t implemented this ?

    Bernd Loigge's profile image Profile Picture

    02d912eb 01cd-49db-bbf5-7c8fd34a8fc2 on 05 Jul 2020 23:10:36

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

    Badly needed. I just got through updated reports for DNS, parameterized, and then republished report only to realize that I can't refresh anymore. wth?

    Bernd Loigge's profile image Profile Picture

    47d26e78 0f11-4847-aaff-3a8cd46e5d3a on 05 Jul 2020 23:10:29

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

    I like the promise of Power BI, please fill in the gaps.

    Bernd Loigge's profile image Profile Picture

    3bfea709 114b-418a-a8cc-88a197560433 on 05 Jul 2020 23:09:42

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

    Hmm how else are we supposed to deal with paginated APIs?? Between this and the much-demanded and delayed incremental updates requirement, MS does seem to have an issue with large datasets.

    Which isn't the most brilliant thing for a business intelligence tool.