Import data into Power BI Desktop from an Excel sheet in SharePoint
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…