Thanks For Reaching out MS Q&A
Make to have Contributor or Owner Role for the ADF.
Check if you have either a Contributor or Owner role on the Databricks workspace resource in Azure.
Role Assignment: Ensure that the service principal is assigned an appropriate role. You can do this by navigating to Azure Portal > Azure Databricks > Azure Databricks Service > Access control (IAM)>Add a role assignment. Select the role as owner > Managed Identity > ADF > Select ADF, then select and then review and assign.
Post granting the owner permissions wait for few minutes and then test the connection and it is successful
For more details, refer to https://techcommunity.microsoft.com/t5/azure-data-factory-blog/azure-databricks-activities-now-support-managed-identity/ba-p/1922818
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click Accept Answer
and Yes
for was this answer helpful. And, if you have any further query do let us know.