Is it possible to write SQL queries for Dataverse calculated columns?

[davidyc]

I have so many situations where I need to roll up a roll up field (i.e. Parent record sums the total of a child record, which is summing the grandchild) in the Dataverse... and I really don't want to have to set up lots of real time workflows to manage this. Therefore I'm wondering if SQL can be used within Dataverse? I know that soon PowerFx can be used with calculated columns but it's not even in preview yet...

[dpoggemann]

Hi @davidyc ,

Quick answer is "no" it can not be used, wish it could!  I usually recommend to look at Power BI for this type of situation and I am waiting on Power Fx to help with a number of these situations.

Hope this helps.  Please accept if answers your question or Like if helps in any way.

Thanks,

Drew