I am using Sql authentication from Power BI for Direct query. **[SFI-ID4.2.2] SQL DB – Safe Secrets ** requires me to remove all sql authentications. What is the best way to authenticate my database from PowerBI. Note: the Azure Sql Server is in PME Tenant.

I tried Microsoft authentication for my credentials but the *microsoft.com is not recognized in AAD for PME and does not allow me to add this user to DB to assign any role

I am expecting a solution where Powe BI reports can access an Azure SQL DB in PME Tenant without using Sql credentials.