cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
davidyc
Helper II
Helper II

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

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...

1 REPLY 1
dpoggemann
Super User
Super User

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

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (5,475)