Hi, I am calling and querying Playfab insights from an Azure function using the Kusto C# SDK.
Sometimes, it throws the following error:
Exception while executing function: PlayfabToBigqueryTimer Request is invalid and cannot be processed: {"error":{"code":"BadRequest","message":"An error occurred.","@message":"'project' operator: Failed to resolve table or column expression named '[\"events.all\"]'","@permanent":true}} {"error":{"code":"BadRequest","message":"An error occurred.","@message":"'project' operator: Failed to resolve table or column expression named '[\"events.all\"]'","@permanent":true}}
I have noted in other questions in this community forum that error is caused by having a newline in the body of the query, but this is not my case.
This is my query FYI:
let users=dynamic(['A0711102A10B8FC4', '86EED972E9EEF454']); ['events.all'] | where Entity_Id in (users) | where EventData['EventName'] == 'LevelEndBubble' or EventData['EventName'] == 'offlineLevelEventsBubble' | project EntityId=Entity_Id, the_date = format_datetime(Timestamp, 'yyyy-MM-dd'), round=EventData['Round'], Playtime=todouble(EventData['PlayTime']) | summarize total_play_days = dcount(the_date), playtime_hrs = round(sum(Playtime)/3600), First_date_played = min(the_date), Last_date_played = max(the_date) by EntityId | join (['events.all'] | where Entity_Id in (users) | where EventData['EventName'] == 'LaunchData' or EventData['EventName'] == 'offlineLaunchEventsBubble' | project EntityId=Entity_Id, Timestamp | summarize total_launches=count() by EntityId) on EntityId | project-away EntityId1
Note: I am using an hourly TimerTrigger in the Azure function to execute my script.
Thanks,
Tarek