cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jzhang
Level: Powered On

Load to Common Data Service failed.

Dear Community, 

 

I have encountered an error message in my PowerApps data loading. I had the same data loading for a couple of weeks now, but this has occured today. I even tried to delete the existing data integration project and tried to remake it, but it still gives the same error message. Does anyone has a solution for this?  Many thanks!! 

----------------------------------------------

Load to Common Data Service failed. Details: [(PQOnline failure - The powerquery job failed with error: Challenge ChallengeType:Resource, ChallengeDataSource:{"Kind":"SQL","Path":"**********;***","NormalizedPath":"**********;***","IsDefaultForKind":false})], One or more errors occurred.. (Job ID: 1d20842e-4185-44f7-8901-db04b*****)

1 ACCEPTED SOLUTION

Accepted Solutions
jzhang
Level: Powered On

Re: Load to Common Data Service failed.

I have contacted Microsoft support, and they have helped me resolve it. Basically it is because there are many SQL connectors that can be used, and powerapps matched the wrong one during the load. They are launching a fix, but a workaround is to delete all the connectors and remake the data integration project. Hope this is useful for other people who had the same issue. 

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Load to Common Data Service failed.

Hi @jzhang ,

Do you mean that you could load the data before but now couldn't?

Are you sure you made the same practice two times?

Could you describe more clearly about how do you import data?

If you could show me screenshoots step by step ,it will be better.

 

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jzhang
Level: Powered On

Re: Load to Common Data Service failed.

I have contacted Microsoft support, and they have helped me resolve it. Basically it is because there are many SQL connectors that can be used, and powerapps matched the wrong one during the load. They are launching a fix, but a workaround is to delete all the connectors and remake the data integration project. Hope this is useful for other people who had the same issue. 

View solution in original post

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (7,720)