Is it possible to set up Power BI Datamart as a linked server in SSMS? I know I can open the Power BI Datamart in SSMS when I utilize the SQL connection string and select 'Azure Active Directory - Universal with MFA' and enter my username https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview?view=azuresql); however, I've tried to set up a linked server and it continues to fail. Thoughts?
I've tried mapping a username in the current database to my azure login with password and it still fails to connect.
