Hi @Shreyas Rastogi
user wants to connect from excel online using Tenant X Credentials from excel online.
I suggest this guest use the Guest email address instead of Tenant X Credentials to connect for a check, because the semantic model is in Tenant Y.
If this user still wants to use Tenant X Credentials to connect, I suggest you post a new thread on the Power BI forum to see if it's possible.
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.