Cannot read using abfss from fabric lakehouse, Error while getting a connection handle. Error Code: 12005: The URL is invalid

[ahjulstad]

I have a parquet file in a fabric lakehouse that I would like to map in duckdb. It works well using the dfs URL az://onelake.dfs.fabric.microsoft.com/xxx/xxxx/Files/xxxx.parquet (just copy pasting from fabric and replacing https with az

but not with the abfss URL: abfss://[email protected]/xxxx/Files/xxxx.parquet

I authenticate using azure cli.

D create or replace view actualcosts as select * FROM 'abfss://[email protected]/xxxx/Files/xxxx.parquet';

IO Error: AzureBlobStorageFileSystem could not open file: 'xxxx Files/xxxx.parquet', unknown error occurred, this could mean the credentials used were wrong. Original error message: 'Error while getting a connection handle. Error Code: 12005: The URL is invalid