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

3bfea709 114b-418a-a8cc-88a197560433 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

de79b29e df1e-4ce5-9118-9871f499d286 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

ef278110 6ec7-4b7d-9dc1-bc65261fbd8a 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

7b83a0b0 eb82-493c-861e-5a3c14cf1ddf 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

d1c1a458 c1eb-4929-b9e4-0d013f27c241 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

89950f4e 72dc-4612-be42-25a0ec1ce73e 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

ff1eead5 351d-45bc-af2c-1360198dac03 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

Bernd Loigge's profile image Profile Picture

4bef5964 38d4-442f-8715-035b560b9790 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

54f1433b c581-40a4-bf86-9e84cd9af446 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

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:06:39

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

Must have feature!