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.
I ended up removing all parameters from my queries and functions in an attempt to get this to load reliably but previosuly this hadn't helped. I also had a recursive query across workbook tabs of an excel file which I had to replace with an equivilent SSIS package and point Power BI at a SQL table even though this worked without issue for many weeks.
On my issue, I have recently heard back from Microsoft support who indicate something has been "fixed" with the cluster and my reports indeed refresh again so perhaps we have different issues with the same error message?
Hi Framet, instead of creating a full SSIS package to create a table you can always create a view to pull the data into your model. Since you are refreshing on a schedule pulling from a view should not be determinal.