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
It works in Power Plattform Dataflow!
RE: Make functions refreshable when the data source is a parameter of the function
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?
RE: Make functions refreshable when the data source is a parameter of the function
Come on Microsoft, this is essential functionality and it been asked for nearly 5 years.
What is the issue that it cannot be implemented?
RE: Make functions refreshable when the data source is a parameter of the function
Please make this work in POWER BI service so i can auto-refresh dynamic web contents queries
RE: Make functions refreshable when the data source is a parameter of the function
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!
RE: Make functions refreshable when the data source is a parameter of the function
This is a much needed feature for Power BI users working on advanced reports!
RE: Make functions refreshable when the data source is a parameter of the function
Any update?
RE: Make functions refreshable when the data source is a parameter of the function
Any update on this?
Thanks
RE: Make functions refreshable when the data source is a parameter of the function
It's 2020 already and this is still a problem. Would appreciate action on this!
RE: Make functions refreshable when the data source is a parameter of the function
It still does not work. Please make it work.