Errors during sync

[murad_athar]

Hello,

Can anyone help me with security filter expression. 

Ref Sample Order Capture App, I have applied following security filter in order details table.

([Order Id].[Order Date])>Today()-30 

And in Orders table, following filter.

[Order Date]>Today()-30.

Records in Order Details table have almost reached 6000 figure.

Can someone guide me in case of above.

Thank you

Murad

[Marc_Dillon]

Guide you with what? Do you have a question? You mention an error, what is the error?

[murad_athar]

Hi Marc 

Thank you for your reply

Actually app is not loading at all. Sync is taking too much time on start up and is not successful. Instead attached error appears even when I have applied security filters.

I want to know if my expressions are correct considering my data is too much.

[Marc_Dillon · Accepted solution]

Yes, your expressions appear syntactically correct. 6,000 records is not very many, the issue is more likely due to having expensive virtual column expressions.

[murad_athar]

Thanks again Marc