Azure Database Auditing not capturing login failures

I'm looking to capture login failures against our Azure Database. I've set up auditing on my Azure Database as such

After running some queries, I can see login successes for the principal in question, shown by the action_id DBAS eg

However, when generating failures both from SSMS and our application, the auditing doesnt capture any failures, which I expect to be shown with action_id DBAF

The info box for this auditing option does say its supposed to capture login failures. Is this a bug or am I doing something wrong here?

Make sure you have given correct file path. Try with below query:

select event_time,server_instance_name,database_name,action_id,server_principal_name,application_name from sys.fn_get_audit_file
('https://banuadls.blob.core.windows.net/sqldbauditlogs/dbservere/db/SqlDbAuditing_Audit_NoRetention/2024-05-31/08_44_54_724_0.xel',default,default)  
where event_time <=  '2024-05-31T09:11:00.5349194'

It is giving login failed error audits as shown below:

For more information you refer to this SO answer.