web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Issues importing query...
Power Apps
Unanswered

Issues importing query from Sharepoint Folder to CDS

(1) ShareShare
ReportReport
Posted on by 2

Hello everyone!!

I have a folder in Sharepoint with some excel files. I used PowerQuery to get the data I want from them, but it fails when trying to load the data to CDS.

 

This is the error:

PQOnline failure - The powerquery job failed with error: Challenge ChallengeType:Resource, ChallengeDataSource:{"Kind":"SharePoint"

 

I have the same question (0)
  • Vijay Tailor Profile Picture
    2,961 on at

    Hi @twralha ,

    Please have a look into the below URL, Hope it will you to resolve your issue.

    https://docs.microsoft.com/en-us/power-query/connectors/sharepointfolder

    Thanks,
    Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    Hi @twralha,

    Are you using Power Query directly in Excel or via Dataflows? If from Dataflows, it seems to be an authentication issue. Try creating a new dataflow with the SharePoint data source with an account that doesn't have MFA enabled. Hope this helps...

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 531 Most Valuable Professional

#2
Haque Profile Picture

Haque 261

#3
Kalathiya Profile Picture

Kalathiya 221 Super User 2026 Season 1

Last 30 days Overall leaderboard