Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 4+iIWlYaP4RB3HBsJgemCf
Power Apps - Power Query
Answered

Extract data from a folder with excel files saved on sharepoint

Like (0) ShareShare
ReportReport
Posted on 8 May 2023 13:11:24 by 12

Hello all. 
I need help to know how I can extract data from Excel files saved in a folder on SharePoint. 
I have been able to link files on OneDrive with no issues. Now I need to rewrite the query to extract data from a folder on SharePoint. I am getting stuck linking the source file to the query. 

Aravind

  • MI-15011544-0 Profile Picture
    2 on 15 Jan 2025 at 15:50:09
    Extract data from a folder with excel files saved on sharepoint
    How do you manage to do so.  I am having issue "Bad Request"
  • aravind_p_m Profile Picture
    12 on 10 May 2023 at 13:39:09
    Re: Extract data from a folder with excel files saved on sharepoint

    Thanks for the directions. Your guide helped me connect to the files using Power query. I was able to retrieve the data from the folder in the SharePoint folder

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,342 Most Valuable Professional

Leaderboard

Featured topics

Loading complete