Notifications
Announcements
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"
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/sharepointfolderThanks,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."
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Kalathiya 321 Super User 2026 Season 1
WarrenBelz 289 Most Valuable Professional
MS.Ragavendar 200 Super User 2026 Season 1