Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

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

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

    Nguyễn Minh Trí on 05 Jul 2020 22:59:29

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

    hope this will be released soon ^_^

    Bernd Loigge's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:57:40

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

    We really need this. The realy good performance of M language is the function. Not to be able to use it in cloud refresh is really a deception.
    Please correct it !
    Regards,
    Hervé

    Bernd Loigge's profile image Profile Picture

    Josimar Gomes on 05 Jul 2020 22:56:21

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

    I need this. How long for deploy?

    Bernd Loigge's profile image Profile Picture

    '@SylvainGrossNeo on 05 Jul 2020 22:55:18

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

    This function is really a must have.
    What is a value of a report if the content can not be automatically refreshed ?
    It's nice that Power BI Desktop support this function, but if in the same time the refresh service does not support it, I can not use the power of this functionnality for my client...

    Bernd Loigge's profile image Profile Picture

    Kevin Brouder on 05 Jul 2020 22:54:49

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

    We also need this for the SharePoint.Tables M query, to be able to call specific sharepoint sites dynamically.

    Bernd Loigge's profile image Profile Picture

    Tom on 05 Jul 2020 22:54:05

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

    I totally agree with this statement: "This is a significant blocker to the realization of the potential of Power BI - bringing data together from anywhere. A huge number of use cases are prevented without this functionality."

    Bernd Loigge's profile image Profile Picture

    Rory Neary on 05 Jul 2020 22:49:31

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

    I agree this is very frustrating, it seems like a pretty minor piece of functionality. I also can't get my head around why you need a gateway to access data that exists in the public domain?

    Bernd Loigge's profile image Profile Picture

    John on 05 Jul 2020 22:49:02

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

    This is a significant blocker to the realization of the potential of Power BI - bringing data together from anywhere. A huge number of use cases are prevented without this functionality.

    Bernd Loigge's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 22:48:43

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

    This would be hugely useful; would love to use the Microsoft Cognitive Services API's. Works great in desktop, useless without scheduled refresh on app.powerbi.com

    Bernd Loigge's profile image Profile Picture

    Josiah Raiche on 05 Jul 2020 22:45:23

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

    My case is recursively grabbing pages from an API. Easy enough to do, but can't refresh in the web. I understand the technical concerns about stack overflows and stuff, but this is still a deal breaker for me.