Semantic model - create calculated column

You can't import a semantic model, to perform additional transformations in it, you need to change from Live Connection to Direct Query, precisely as you mention. If you don't want to change that, you have no other choice than to work with a copy of the semantic model, if you have it then that's great, if not, explain your case to the semantic model owner and request him a copy.

Hello lafakios ,

Thank you for your question, also thank you ray_aramburo  for the helpful input.

As mentioned, Live Connection mode limits you to measures and doesn't allow adding calculated columns. To perform those calculations, you’ll need to switch to DirectQuery mode, which provides more flexibility.

However, as ray_aramburo pointed out, DirectQuery may impact performance with large datasets. If performance becomes an issue, you could ask the owner of the semantic model for a copy to import locally and perform the calculations directly. Alternatively, consider using a composite model for a balance of performance and flexibility.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thankyou.