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

caebb890 8faf-4423-8444-8c7464eb4576 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

9480cdac 8928-4314-920b-1d67563100e9 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

cfd4c8b7 beed-4f52-b257-baf2ec6a664d 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

a3309361 99be-ea11-a812-000d3a8ddfb2 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

23e8a315 a219-47b2-8e9d-fa379c115c2a 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

bff1bf7e 8ad3-40b9-9ece-0297be8f9643 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

b2be9356 e508-47a0-8b7f-d11d0989272a 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..

Bernd Loigge's profile image Profile Picture

5b11fcd1 9b1a-460b-87f9-5a0b001c9263 on 05 Jul 2020 22:42:51

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

Very frustrated it hasn't got any update!!

Bernd Loigge's profile image Profile Picture

b19ab3bf 92ec-4a01-b47c-677a68c53d21 on 05 Jul 2020 22:42:48

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

Hi All, any updates ?

Bernd Loigge's profile image Profile Picture

2c649e72 ddf6-439c-85af-4e55d1443c5c on 05 Jul 2020 22:42:02

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

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