In this article, you will learn how to import data into Power BI Desktop from an Excel Sheet stored in SharePoint document using the following steps:

• From SharePoint, open the file in excel, copy the file path and remove? web=1 to look like URL below

https://rkc.sharepoint.com/Shared%20Documents/My%20Files/Products.xlsx

• On Power BI Desktop, from Get Data choose Web connector

 

• Enter the above URL and click OK

• Choose your authentication method, for this example I am choosing Organizational account

• Click sign in to choose your account and connect

Dang! here is your data. You are now connected, you can choose to Edit or Load directly to Power BI