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!