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

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

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

As much as functions are stressed in the Power BI and Power Query Deep Dive presentations, it is instrumental to allow us to use functions to fully utilize the capabilities of Power BI. I am currently refreshing and republishing the data manually several times a day, which over time, will drive us to search for another solution.

Bernd Loigge's profile image Profile Picture

Aliaksei Liavitski on 05 Jul 2020 23:07:23

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

It's very important feature. Anybody knows any workaround to refresh data from online app? In my case I load data from JIRA's API as source. I am using Json.Document(Web.Contents()) but parameters passing to URL from table. It means I generate table with column A with parameter values and then create custom column where data from source stored - Table.AddColumn(#"table", "data", each Json.Document(Web.Contents("" & "?parameter=" & [parameterValue]))).

Bernd Loigge's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:06:39

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

Must have feature!

Bernd Loigge's profile image Profile Picture

Andy Trezise on 05 Jul 2020 23:06:25

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

Needs fixing quickly. Just spent 3 hours designing a report - all works fine on the desktop but as soon as I publish and try to set up the scheduler I find it's unsupported because of functions I've used in setting up the source data. :-( :-( :-(

Bernd Loigge's profile image Profile Picture

Scott on 05 Jul 2020 23:06:09

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

Absolutely a must. This stalls the functionality of most of the dashboards I create.

Bernd Loigge's profile image Profile Picture

James Russell on 05 Jul 2020 23:06:08

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

100% frustrating to go through the process of preparing reporting using the List.Generate function to only find it won't refresh in the service. This feature is needed ASAP.

Bernd Loigge's profile image Profile Picture

Emmanuel LASSALLE on 05 Jul 2020 23:06:08

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

Indeed a MUST-HAVE feature. Please provide urgently as this is a blocking factor for us !

Bernd Loigge's profile image Profile Picture

Patrick on 05 Jul 2020 23:05:46

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

Very needed functionality. Please add asap.

Bernd Loigge's profile image Profile Picture

kislam on 05 Jul 2020 23:05:43

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

This needs to be implemented super urgently!

Bernd Loigge's profile image Profile Picture

Jeremy Jack on 05 Jul 2020 23:04:31

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

Well that's pretty poor. One step forward. One step back.