Skip to main content

Power BI

Needs Votes

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

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

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.

Bernd Loigge's profile image Profile Picture

Power BI User on 05 Jul 2020 22:45:08

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

Very annoying this hasn't any update in 2 years....I think is a must have. Any ETA, PowerBI team?

Bernd Loigge's profile image Profile Picture

Power BI User on 05 Jul 2020 22:44:05

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

Superb that's working in Desktop.. nevertheless worthless if scheduled refresh cannot handle his. Please Fix..