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

Martijn 1 Reputation point
2020-09-04T15:56:30.983+00:00

Hi,

When I try to add a calculation group to a clean SSAS tabular 1500 project in direct query mode linked to a single SQL Server table, I get the following error:

Failed to save modifications to the server. Error returned: 'All partitions using DirectQuery mode with Full DataView must query the same data source'.

Since it is a clean project with a single data source/table, I assume something else goes wrong here.

Could someone please confirm that calculation groups are compatible with tabular models in direct query mode?

If so, what am I missing here?

SQL server 2019 and SSAS run on the same machine and are patched to CU7.
Visual studio 16.7.2
Microsoft Analysis Services projects 2.9.12

Thanks,
Martijn

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,282 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,821 Reputation points
    2020-09-07T02:02:20.39+00:00

    Hi Martin,
    As states in Deploying DirectQuery models

    Calculation Groups should be supported in DirectQuery mode, and we need to do Process Recalc after deloy or saving to server.

    Regards,
    Lukas

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.