Showing results for 
Search instead for 
Did you mean: 
New Member

Issues importing query from Sharepoint Folder to CDS

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"


Resident Rockstar
Resident Rockstar

Hi @twralha ,

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

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."

Super User
Super User

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...

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,440)