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 (117)
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
RE: Make functions refreshable when the data source is a parameter of the function
For one of our customer we would need this...
RE: Make functions refreshable when the data source is a parameter of the function
yes it gwould be very useful. I'm getting a lot the "You can't schedule refresh for this dataset because" error
RE: Make functions refreshable when the data source is a parameter of the function
Any updates here please? Really useful to have to this....