1191
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.
STATUS DETAILS
Needs Votes

Comments

B

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.

B

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.

B

Need This Feature ASAP..

B

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

B

Any update here? Potential workarounds for parameterized ODBC DSNs?

B

Need this!

B

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.

B

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

B

PLEASE!!!!!

B

Any updates on this? Having M work in desktop but not in the service is a real headache; getting this fixed would really help with keeping report development/publishing a more seamless process.