How do you use calculation groups in data from a Power Bi Shared/Direct Query model into your local?

[Koushikrish]

We are pulling in data from 3 different shared data models into a composite model for our project. As part of one of these 3 models, there are some calculations for formatting done via Tabular Editor and these are not applying on to the local composite model. How do we accomplish these on the local composite model? Are there any workarounds for these?

[V-lianl-msft]

Hi @Koushikrish ,

As far as I am concerned,Calculation groups on remote sources are not supported, with undefined query results.

If the import mode is used, will the calculation group be created successfully?

https://powerbi.microsoft.com/en-ca/blog/directquery-for-power-bi-datasets-and-azure-analysis-servic... 

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