Create table in data explorer(advanced)

Data Explorer (advanced) is an event-based data manager, you can refer to Getting started with Data Explorer advanced mode - PlayFab | Microsoft Docs to use it, just to clarify that it is not designed to export player data.

For example, use the following statement to get these event data named player_virtual_currency_balance_changed, but these data are more for analysis rather than being stored in the database as player data.

If you want your database to sync player virtual currency balances, then you can use a rule that calls an Azure Function to write data to the database when player_virtual_currency_balance_changed is triggered.

['events.all'] 
| where FullName_Name == "player_virtual_currency_balance_changed"
| project  Entity_Id, EventData.VirtualCurrencyName, EventData.VirtualCurrencyBalance, Timestamp