Make functions refreshable when the data source is a parameter of the function
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.
Kristian Bubalo commented
We also need this function really urgent! Customers do not want to use Power BI if funtctions are not refreshable
Michael Shparber commented
Super needed! Thanks!
Please add this
John Dawson commented
We absolutely need this! Our data sources are paged, and functions are the only workable way of getting data
Nguyễn Minh Trí commented
hope this will be released soon ^_^
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 !
Josimar Gomes commented
I need this. How long for deploy?
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...
Kevin Brouder commented
We also need this for the SharePoint.Tables M query, to be able to call specific sharepoint sites dynamically.
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."
Rory Neary commented
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?
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.
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
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.
Very annoying this hasn't any update in 2 years....I think is a must have. Any ETA, PowerBI team?
Superb that's working in Desktop.. nevertheless worthless if scheduled refresh cannot handle his. Please Fix..
Very frustrated it hasn't got any update!!
Hi All, any updates ?
This looks to me like a product maturity issue, Oracle SAP provide this functionality in scheduling facilities whereas PowerBI only provide it for desktop which is in effect of little value to a production environment. My work around is to create the same functionality in excel and publish to SharePoint which is OK as the dimension changes rarely and the user refreshes the model when needed
Yikes, this breaks my 26 reports for auto updates. Would be nice to have parameters included in the data src. Looks like I will manually link each src file.