We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

SSAS queries not working when calculation groups are used with the Accelerator

Answered
Miguel Duarte asked on February 10, 2021

Hello,
Wa are having some issues with Flexmonster when using the Calculation Groups feature from SSAS Tabular (Power BI Premium) along with the Accelerator.
When I try to exercise one of the calculation groups on our models, I get errors like this one:

Query (1, 677) The following syntax error occurred during parsing: Invalid token, Line 1, Offset 677, ]. Technical Details: RootActivityId: 4116f850-d0f0-4678-8654-851634bf5053 Date (UTC): 2/10/2021 8:31:52 AM

Can imagine it is an error due to this feature not being supported. Can you confirm this?
(Attached a screenshot)

Attachments:
calc groups.jpg

2 answers

Public
Vera Didenko Vera Didenko Flexmonster February 10, 2021

Hello, Miguel,
 
Thank you for your question. 
 
We would like to kindly explain that calculation groups are not supported at the moment.
As we understand, calculation groups is a relatively new feature available in SQL Server 2019, MS Analysis Services, Azure Analysis Services, and Power BI Premium. 
Our team will look into this feature in more detail, and we will notify you in case of any updates on the matter.

Please let us know if any other questions arise in the meantime.
 
Kind regards,
Vera

Public
Miguel Duarte February 11, 2021

Hi Vera, thanks for the clarification.
Best,
Miguel

Please login or Register to Submit Answer