Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Problem:
Uploading a pbix file with custom function calls to a parameter.
Details:
Parameter: "12345//abcdefgh//klmnop"
Function: "Splits the parameter by "//", returns the correct part of the parameter based on an input value)
Query: "Source = Function("FirstValue")"
Returns: "12345"
It works great to refresh and have function calls either directly in the Query with position/split functions or by a custom function call ("Function") locally in the pbix file. When uploading the pbix to the service with function calls to control what part of the parameter should be fetched in the query it's not possible to either refresh nor schedule a refresh:
"You can't schedule refresh for this dataset because one or more sources currently don't support refresh."
I've seen a work around for this problem written by Chris Webb:
In my case the work around did not work, it's a slightly different approach in Chris Webb's case (he uses Web.Contents, I'm using an odata call).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.