Tenant A will need to provision an identity for Power BI to use. That can be a SQL Login/Password (Power BI calls this "Basic"), an Entra ID Service Principal, or an Entra ID Guest User.