I was able to mount the storage when I used a linked service that used a private endpoint. Looks like my organisation had locked down the linked service that was missing the private endpoint.
Now that it's mounted, the Geopandas read is still not seeing the file as if it was on the local storage. Mounting the storage should have worked - or is there another consideration that I am missing?
e.g.
mssparkutils.fs.mount(
"abfss://******@mydatalake.dfs.core.windows.net",
"/temp",
{"linkedService":"DL_Linked_Service"}
)