Power BI
Needs VotesMake functions refreshable when the data source is a parameter of the function
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 (122)
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.
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
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.
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]))).
RE: Make functions refreshable when the data source is a parameter of the function
Must have feature!
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. :-( :-( :-(
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.
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.
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 !
RE: Make functions refreshable when the data source is a parameter of the function
Very needed functionality. Please add asap.