We have a SSAS that retrieves data from a MySQL using a scheduled job, which invokes the Refresh command with the "full" refresh type (see https://docs.microsoft.com/en-us/analysis-services/tmsl/refresh-command-tmsl?view=asallproducts-allv...
This job started failing due to "out of memory" and "MySQL: timeout reading communication packets" errors.
So I changed the refresh type to "automatic" and worked fine, since adding more memory is currently not possible. The job finishes, and after manually updating the dataset in powerbi.com, new dates appear in the reports' filters, as if new data is available, but it is not shown:
If I change the filter to display data from march, it works (all new data is from april and may).
I tried executing the refresh command using types "calculated" and "add", but the model has calculation partitions and didn't worked. I don't know exactly what "clearValues" does, so I didn´t try it.
Also on-premises data gateway is updated to the latest version.
Any suggestions?
Thanks.