Azure data factory can be used to create a pipeline that will copy data from SQL pool to Blob storage. This pipeline can be scheduled to run daily or schedule as required.
In below document, just replace SQL server settings by SQL pool settings
https://learn.microsoft.com/en-us/azure/data-factory/tutorial-hybrid-copy-portal
----------
Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav