1180
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.
STATUS DETAILS
Needs Votes

Comments

B

any improvements or workarounds ?

B

This functionality really needs to be added asap!

B

It works in Power Plattform Dataflow!

B

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?

B

Come on Microsoft, this is essential functionality and it been asked for nearly 5 years.
What is the issue that it cannot be implemented?

B

Please make this work in POWER BI service so i can auto-refresh dynamic web contents queries

B

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!

B

This is a much needed feature for Power BI users working on advanced reports!

B

Any update?

B

Any update on this?

Thanks