Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

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

    Vote (1230) 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

    Wade McGriff 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

    Michael McClarin 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

    Power BI User 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.

    Bernd Loigge's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:09:42

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

    Its so frustrating when I can build a report in desktop, have it all working perfectly and then as soon as I publish it things no longer work... please stop doing this!

    Bernd Loigge's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:09:42

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

    need the automatic refresh at any situation.

    Bernd Loigge's profile image Profile Picture

    Sanaa on 05 Jul 2020 23:09:42

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

    This feature will make life much easier and the use of the tool much more convenient.

    Bernd Loigge's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:09:39

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

    This is a must requirement for me as well, as I am refreshing the data from Jira web with pagination manually.

    Bernd Loigge's profile image Profile Picture

    Mick Power BI User on 05 Jul 2020 23:08:40

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

    This is a HUGE requirement for Power BI Service. Need to refresh SharePoint list data using a function.

    Bernd Loigge's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:08:20

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

    This is a much needed feature! Note that a workaround is to use PowerBI Report Server on premise, the refresh works with functions.

    Bernd Loigge's profile image Profile Picture

    peter hanna on 05 Jul 2020 23:08:17

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

    Power BI is a great tool, but this limitation makes it very weak. please solve quickly