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

[bloigge]

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.

[T_Justin_Allen]

PLEASE!!!!!

[mikec4]

Just a thought, I wonder if DataFlows would get around this limitation? But is oData supported in DataFlows just yet?

[dylan_janszen]

Pleaseeee add this Power BI team. I have a list of parameters that my team keeps updated in Google Sheets as that is their preferred method, but I can't refresh pulling from this external source. Need this data to make my API calls in Power BI.

[hcates]

Need this!

[dagostino_ja]

Any update here? Potential workarounds for parameterized ODBC DSNs?

[rux]

I Need this too, asap I dont understand how other users can work without this feature, when tables have Millions of entries and only one day/month/year is important... Why is it so difficult, to give a User-Prompt for Parameters, when need

[nstewart1]

I had to take my code out of the function and into the body of Power Query code itself. Kind of messy. Would like to use functions.

[firasdawood]

Need This Feature ASAP..

[jeffhome43]

Allow the user to choose, from a parameter drop down a server they ewant to look at. The parameter either populated from a list or query, and the datasource changed accordingly, (the last bit I can do). It would be great to add this feature, you cannot really allow users access to the desktop versin, you want them to use the server versin, but it is really tough if you cannot use a parameter to drive what the user sees.

[Giovanni_Miragl]

Any Update?