Forum Discussion
SBPFA
5 years agoHelper I
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...
GilbertQ
5 years agoSuper User
Hi SBPFA
What happens if you have to change the partitions to be monthly instead of the past N years.
What I mean is change the partitions from the last 2 years to the last 24 Months, this will run a query to process each partition monthly which can return the data quicker.
SBPFA
5 years agoHelper 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.