Forum Discussion
Report does not display refreshed data
Hi,
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-allversions#request).
This job started failing due to "out of memory" and "timeout reading communication packets from mySQL" errors.
So I changed the refresh type to "automatic" and worked fine, since adding more memory is currently not possible. The job runs fine, 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.
2 Replies
- SBPFAHelper I
Hi Gilbert, I was doing some research to see how to achieve that, and found a post from you in Frour Moo: https://www.fourmoo.com/2020/12/02/how-i-changed-the-partition-configuration-year-month-quarter-days-for-my-data-in-power-bi-premium-power-bi-premium-per-user/
Unfortunately I don't have Power BI premium. Is there another way?
Thank you and sorry for the delayed answer.