Forum Discussion
Schedule refresh stopped working.
Apparently Microsoft have made some changed to the service - atleast I am now able to schedule refresh on republished data models.
By further investigating I have narrows my issues down to the following to lines of code where I loop over the different companies and then merge the result into one table...
LoadCompanies = List.Transform(Company, each Companies(_)),
CombineData = Table.Combine(LoadCompanies),
The parameters (" & Company & ") in the code is not the issues - if I create a static parameter for company (like my server and database parameters) and publish this model to the service I am able to schedule the refresh.
I suspect that MS in the lastest change to the service have made some kind validation against the SQL source, but my company parameter is a list of values and not just one value, hence validation is not posible, because the company parameter is unknown until the list is populated with values and used in the function. It's really anoying - we have been using this technique since the summer of 2016 and have sevaral customers that is using our models, and right now we can't make changes to any of these or install the models at new customers.
Apparently Microsoft have made some changed to the service - atleast I am now able to schedule refresh on republished data models.