I have a CountRows formula that was using an Azure SQL DB table as the source.
I am (99%) sure that previously this was not flagged as non-delegable, but starting today, it is. The formula is on the Visible property of an icon which is hidden most of the time, so perhaps the change is just that the blue warning circle was not previously showing for hidden icons.
I have modified my formula for CountRows so that the source is a Gallery (which is based on the Azure SQL DB table) and all is well again.
I'm just curious as to whether this is something I missed or whether there has been a change that makes CountRows non-delegable for SQL tables.
I get the message that says "Part of this formula cannot be evaluated remotely. CountRows operation is not supported by this connector/service." I am using an on-premise SQL database. However, the function is working at the moment and returns the correct count. I'm just afraid it's going to stop working at some point. And I agree, the message wasn't there originally.
So CountRows was never delegable but has only recently started as showing as such in the designer (with the blue warning dot)?
I find it concerning that this was not being properly flagged (blue warning dot) previously. I am trying to ensure that all my data calls are delegable so that I won't hit performance problems or the 500 record return limit as my data grows, and I have been relying on the warning within the designer to know when there is a potential issue.