Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 the Calculation itemjs and groups from the dataset, the refresh issues have stopped. Has anyone faced this issue and is there a way to get around this? Thank you in advance Team!

Need Help

6 Replies

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi Anonymous,

     

    Could you provide the relevant error message?

    Please refer this about requirements of Analyze in Excel.

     

    Best Regards,
    Link

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Here is a screenshot of the error message

    • v-xulin-mstf's avatar
      v-xulin-mstf
      Community Support
      5 years ago

      Hi Anonymous

       

      Please refer this related post and check.

       

      Best Regards,
      Link

       

      If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • bdarbo78's avatar
    bdarbo78
    Advocate II
    5 years ago

    Hi @saylivaidya

     

    I was having the same error but luckily your post got me on the right track. Even though the calculation group was not used in the pivot table, it also caused the same error message. Whith the calculation group removed, the refreshing is now OK again.

    This is a big disapointment since calculation groups can be so useful. Just as Analyse in Excel. But we need both !

    ms: please give us a fix or workaround !

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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.

      • bdarbo78's avatar
        bdarbo78
        Advocate II
        5 years ago

        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.