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

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.

B

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.

B

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

B

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.

B

This needs to be implemented

B

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!

B

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

B

this is really important

B

I have a parameter based report, refresh works on it. I have connected the report through my own developed web api. Using a azure app function proxy. The report refreshes nightly after uploading to powerbi cloud

B

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