Open the original report in Power BI desktop, go to Query Editor-> Advanced Editor, modify. Now you get the link, please remove ?web=1 string at the end of the link as mentioned in the article.
The excel is now placed in Microsoft Teams site.I have been provided an url to link teh Power Bi report.Learn about premium Outlook features that come with Microsoft 365. A Microsoft 365 subscription offers an ad-free interface, custom domains, enhanced security options, the full desktop version of Office, and 1 TB of cloud storage.
Click the button to add display the 'Add a tab' dialog, as shown in Fig.
2 shows the list of tabs at the top of a channel. 1 shows the Microsoft Teams interface (with my organization's Teams, channel's and conversations covered up).