How To Connect to an Excel File on SharePoint Using Power BI

How To Connect to an Excel File on SharePoint Using Power BI

There’s a new and much easier way using the file path from Teams.

1) From Teams, select the three dots, go to details, scroll down on the right side and find the path to copy.




4) Use that path to connect to web from Power BI

——————————————-Other way with more steps below——————————————————

1)  Open the file on SharePoint in the Web

2)   Click on the Editing drop down menu

3)  Click on Open in Desktop App

     

4)  In the Excel Desktop App, Click File

5)  Click Info

6)  Click Copy path


7)  Open Power BI Desktop

8)  Select Get Data

9)  Select Web


10)  Paste in the path from file

11)  Remove text from ‘?’ to the end of the string (should end in .xlsx)

          

12) Select OK

13) Choose Organizational account for authentication

Leave a Reply

Your email address will not be published. Required fields are marked *