Pivoting Query Issue ADX

ADX 156

I have data in my table like below.

after pivoting the data looks like

I have build the query for this. But i want to check the date filter condition dynamically if there is no data for the given date it should return empty instead of error.

I am passing the another Indate value where data is not exists in the table with that date.In that case its throwing an error mentioned below.

I know the error is because no data in the table for the input date and we are selecting the Pivoted columns in the project. Can we do anything if no data exists for the given input date then it should not execute the statement lineno:6 i mean | project EventUTCDateTime,OPERATOR,PROFILE

PRADEEPCHEEKATLA-MSFT 77,751 Reputation points Microsoft Employee

2022-04-22T05:06:08+00:00

Hello @ADX ,

We are reaching out to the internal team to get more details on this issue. I will be update you once I hear back from the team.
ADX 156 Reputation points

2022-04-29T09:43:10.943+00:00

Would be great if you have some inputs on this issue and suggest the same to me.