By default, Only Lists appear in the Navigator. Once you are successfully logged in, You’ll get the Navigator page to choose your source list and click on “Load”. For Office 365, choose organizational credentials. Provide the URL of your SharePoint site and choose the Authentication method accordingly – I Selected Windows. To extract SharePoint list data, click on the “From Other Sources” button from the ribbon and choose “From SharePoint List” Once installed, You’ll find a new tab “Power Query” tab added to Microsoft Excel. To start with, Download the Power Query Add-in for Excel from: Step 1: Download & Install Power Query Add-in ![]() Let’s see how to extract SharePoint list data using Power Query for Excel. ![]() Microsoft Power Query is a free add-in for Excel – Part of PowerBI that provides self-service Business Intelligence features.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |