Cannot add calculation group to SSAS Tabular 1500 with direct query to SQL server

Tlou, Violet 21 Reputation points
2020-09-29T06:26:35.977+00:00

Hi, I am not able to create calculation groups on my direct query model. My tabular model is based on a single db
source but I cannot seem to solve for the error when I need to create calculation groups. Neither tabular editor
or visual studio are allowing me to proceed with this. Can anyone help with direction on this? Calculation groups are supported
according to MsDocs but somehow this is a challenge on my side.I have checked partitions and ensured all full data view partitions are in
direct query model - again all pointing from a single sql server source.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
0 comments No comments
{count} votes

Accepted answer
  1. HarithaMaddi-MSFT 10,136 Reputation points
    2020-10-01T09:45:55.85+00:00

    Hi @Tlou, Violet ,

    Welcome to Microsoft Q&A Platform. Thanks for posting the query.

    As per the documentation, below is mentioned as a limitation. Also, I have reproduced and observed the same. Please suggest any other document that is referred to in this context.

    29671-image.png


0 additional answers

Sort by: Most helpful