Make functions refreshable when the data source is a parameter of the function
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.
Johnny LaBonny commented
This is an essential feature to automate large datasets creation! Ff this is hard to code can an alternative be provided? Is there anyway to work around this?
Ben van den Berg commented
Come on Microsoft, this is essential functionality and it been asked for nearly 5 years.
What is the issue that it cannot be implemented?
Xander kamphuis commented
Please make this work in POWER BI service so i can auto-refresh dynamic web contents queries
We have a SaaS multi-tenant system with 1000 On-premise SqlServer databasees with the same schema in each database, one database for each tenant. I am building a common dataset for all tenants, so that we can do reporting on top of all the tenants.
This can only be done with a function where the datasource takes “Server” and “Database” as a parameter. We have a table with all tenants listed, with columns for “Server” and “Database” where the tenant “lives”. Then we loop through all the tenants for each entity, call the function with the Server and database as parameters, and appends the data for each tenant into one dataset.
This is working PERFECT in Power BI Desktop! But I was very frustrated when I published the working dataset and report to Power BI Service. It would not refresh! We got an error message saying that referencing a “Dynamic data source” was not allowed. This is just because of the parameter in the data source in the M-function. So, in my case Power BI is useless!
Same problem exists in the Data Flow! I moved all my queries into a Data Flow, and same problem happened! I got the same error when I tried to save the data flow with the M-function that had parameters with “Server” and “Database” in the data source. So, Power BI Data Flow was also useless for me!
I’m sure this “Dynamic data source”-issue is a big problem for many companies! I really hope this serious weakness is being prioritized now!
This is a much needed feature for Power BI users working on advanced reports!
Jordan McCann commented
Any update on this?
Arbi Borje commented
It's 2020 already and this is still a problem. Would appreciate action on this!
It still does not work. Please make it work.
Please let us know this is on the roadmap!
Guillaume Brunet commented
This has been asked over 4 years ago. It's a severe gap not to have it.
This would be a much appreciated feature, please do add this functionality.
Can u please add this feature? I have a great report which contains lots of parameters as functions for odata, without web service refresh power bi is not useful.
seems this idea posted on Aug 14th 2015, it is exactly 4 years for today. how many votes required to add this functionality any idea to any one?
Roy Munoz commented
Please add this functionality
Jeff Westcott commented
Allow the user to choose, from a parameter drop down a server they ewant to look at. The parameter either populated from a list or query, and the datasource changed accordingly, (the last bit I can do).
It would be great to add this feature, you cannot really allow users access to the desktop versin, you want them to use the server versin, but it is really tough if you cannot use a parameter to drive what the user sees.
Neil Stewart commented
I had to take my code out of the function and into the body of Power Query code itself. Kind of messy. Would like to use functions.
Need This Feature ASAP..