Thanks for using Microsoft Q&A !!
Unfortunately, you cannot import .dbf file directly to Azure SQL. You can convert your .dbf file to CSV using Custom Activity to a Blob then you can try importing CSV from your Blob to your Azure SQL instance using Copy Activity in ADF.
Please refer to Use custom activities in an Azure Data Factory on creating a custom activity.
Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.