Forum Discussion
Helper IIIScheduled refresh doesn't with parameters
Doesn’t anyone know a work around to enable schedule refresh with parameters.
i have few tables pulling data using a parameter. below is the M code for one function and then the M function for the processed data.
Any help would be greatly appreciated.
2 Replies
- lbendlin
Super User
Those are not parameters. You are trying to run a completely random URL extract (as far as Power Query is concerned). Scheduled refresh expects a "base" URL that stays constant, and parameters would only be used to modify the rest of the URL.
In your case you would need to hard code the CLIENT part to make it work, and likely do that in a normal query rather than in a function.
deevsI have hard coded that in the function but still it wouldn’t work.
Can’t think of any other way to get his done without having to use a function. Can you suggest any ?
At the moment what’s happening is that there is a look up table that pulls from API and then using a function to iterate each entity through API.
