Power BI

Needs Votes

Make functions refreshable when the data source is a parameter of the function

Vote (1047)

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)

Comments (117)

29459f8a da2b-48b3-b5ca-8da5290c7e76 on 05 Jul 2020 22:21:49

RE: Make functions refreshable when the data source is a parameter of the function

When i create a power query report with function to retrieve data from muliple project sites the refresh/schedule option is not working. It should be resolved soon

ad540b72 ce88-e711-812c-e0071b660ff1 on 05 Jul 2020 22:21:09

RE: Make functions refreshable when the data source is a parameter of the function

This is so needed! I wish I wouldn't of spent a day building out what I thought was a brilliant ETL approach for multiple servers with identical schemas. Please find a way to make this happen.

534b4794 e3ed-4cb5-8ee9-18f12d33d93a on 05 Jul 2020 22:20:14

RE: Make functions refreshable when the data source is a parameter of the function

3 votes! To let Power BI to be a really powerful tool we have to enable this. The situation when some features only work for a desktop client is truly unacceptable

2f52ef19 1f03-42c9-96e0-2eb831045dd3 on 05 Jul 2020 22:17:20

RE: Make functions refreshable when the data source is a parameter of the function

I call the same data source (URL) over multiple API endpoints, in case the URL needs to change I have each data source reference a single table parameter. I've now discovered this means refresh cannot be scheduled.. Seems like an obvious thing really.. 3 votes!