Power BI
Needs VotesMake functions refreshable when the data source is a parameter of the function
Bernd Loigge on 14 Aug 2015 03:16:28
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.
- Comments (120)
RE: Make functions refreshable when the data source is a parameter of the function
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.
RE: Make functions refreshable when the data source is a parameter of the function
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.
RE: Make functions refreshable when the data source is a parameter of the function
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.
RE: Make functions refreshable when the data source is a parameter of the function
Please add this functionality, we would need it for our project =(
RE: Make functions refreshable when the data source is a parameter of the function
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.
RE: Make functions refreshable when the data source is a parameter of the function
This needs to be implemented
RE: Make functions refreshable when the data source is a parameter of the function
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!
RE: Make functions refreshable when the data source is a parameter of the function
would really need this functionality in order to make my report work
RE: Make functions refreshable when the data source is a parameter of the function
this is really important
RE: Make functions refreshable when the data source is a parameter of the function
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