Forum Discussion
Refreshing queries with functions doens't work
Maybe try this approach..and filter the latest file by date created..Needs more code but it worked - refreshed in PowerBI V1 so probably it will work in V2 as it doesn't use parameters..
Yep, same issue here. source wrapped in a function appears not to be refreshable from the portal.
This is currently correct; queries where data access happens inside a function and where the data source is dependent on parameters to the function can't currently be refreshed. That's because we're doing static analysis of the query to discover the data source, and our static analysis can't yet handle this scenario.
any timetable on that? depending on the size of my reports without functions code gets a mess really fast...
Do you need the ability to call the same function multiple times? That is, does your code look more like
let
function = (url) => Web.Contents(url),
result = function("http://foo.com/bar"),
in
result
or like
let
function = (url) => Web.Contents(url),
result1 = function("http://foo.com/bar"),
result2 = function("http://foo.com/baz"),
result = Binary.Combine(result1, result2)
in
result
?
