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.

[pbiideas1]

For one of our customer we would need this...

[cbsantos1]

this is really important

[iyu]

would really need this functionality in order to make my report work

[d_frazier]

I tried building a refreshable M Query using Datachant's iterative function here: https://datachant.com/2016/06/27/cursor-based-pagination-power-query/ and Chris Webb's method to trick the Web.Contents () static analysis of the URL here: https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi/ BUT this combo doesn't seem to work. Any modification to the Web.Contents () text string that's passed into the function breaks the GeneratedList function. HELP!

[alison_hughes]

This needs to be implemented

[joabenman1]

Please add this functionality, we would need it for our project =(

[redmond_hartop2]

More needs to be done to iron out the discrepancies in the execution of desktop and service M code. This idea highlights this need. In the meantime this blog: https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi/ provides a useful workaround to automating some uses of functions and parameters. You may find though that switching the argument 'Query' for 'RelativePath' is more effective for your project.

[fbcideas_migusr]

Just published a report that used this functionality...only to find it isn't there. Hope you guys can make this work at some point.

[matthew_montgo1]

This thread is three and a half years old...are there any plans to implement this? Not offering this functionality in the online refresh is essentially punishing users for trying to keep their queries and M code neat and organized with functions.

[erkau_daniel]

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.