Forum Discussion
Analyze in Excel unable to refresh after adding Calculation groups in dataset
We have recently added dynmaic measures using Calculation groups and Tabular Editor to a dataset. We have noticed that it has caused refresh fail error with Analyze in Excel files. When we removed th...
Exactly. We were getting ready to get rid of 100s of time intelligence measures, as we include calculation groups to create dynamic meausres. We might have to put that on hold for a while, until there is a solution. Analyze in Excel is a more important feature for company needs.
After experimenting, it appears that in my case the root cause of the pb was the use of dynamic format string expressions. By removing those expressions in the group items, the issue disappeared. I was using "SELECTEDMEASUREFORMATSTRING ()" but did not try to used fixed formats.