In this article you'll learn how to connect to an Excel file saved on a SharePoint document library.

Go to the desired document library on SharePoint, the follow the following steps:

1. Select the Excel file
2. Click the Open button 
3. Click Open in app 

The Excel application will open on your computer. Follow the following steps in Excel: 

4. Click the File menu 
5. Click Info 
6. Click the Copy Path button 

Next, open Power BI. 

7. Open a new file and select Get data
8. Click Web

9. Paste the path coped from Excel in the URL text box 
10. Delete the ?web=1 from the end of the copied path 
11. Click OK 

12. From the Access Web Content page, click Organizational account 
13. Click Sign in and type in your credentials in the popped out window 
14. Click Connect 

Now, you should able to select tables for sheets and start building your report.