Follow these steps to connect Power BI to an Excel document stored on Teams:
- On Teams, Go to files.
- Right click the the file and select open in Excel app.
- On Excel, Click on "Info" & copy the path
- Go to Power BI > Get Data > From Web > Basic
- Paste the link from Excel file.
- Remove the "?web=1" from the end of the link. Then click on "OK"
7. If a security pop-up comes, Click on Organisational Account>Sign in> then enter your kemin credentials>then click on connect
Troubleshooting
If you encounter any issues while connecting Power BI to your Excel document stored on Teams, try the following troubleshooting steps:
- Check that you have the necessary permissions to access the Excel document on Teams.
- Verify that the Excel document is not open in another application.
- Ensure that the file path is correct and that the file has not been moved or deleted.