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

CDS Load Failed Azure DB Data Source - PQOnline Failure

I'm working with a sandboxed environment and trying to load data to the CDS. I receive the following error in the last step:

Load to Common Data Service failed. Details: [(PQOnline failure - The powerquery job failed with error: Challenge ChallengeType:Resource, ChallengeDataSource:{"Kind":"SQL","Path":"sql-server-path.database.windows.net;sql-db-path-data-test","NormalizedPath":"sql-server-biinsite-test.database.windows.net;sql-db-path-data-test","IsDefaultForKind":false})], One or more errors occurred.. (Job ID: b035cd92-79ea-4c29-b582-98fff42823d6)

What are the steps to resolve?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: CDS Load Failed Azure DB Data Source - PQOnline Failure

Hi @redlead3 ,

 

Did you follow the steps in below documentation correctly?

https://powerapps.microsoft.com/fr-fr/blog/load-data-from-external-data-sources-to-the-common-data-s...

 

Were you trying to load to an existing entity or a new entity?

 

Since this is still in preview, did this work before for you?

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: CDS Load Failed Azure DB Data Source - PQOnline Failure

Hi @redlead3 ,

 

Did you follow the steps in below documentation correctly?

https://powerapps.microsoft.com/fr-fr/blog/load-data-from-external-data-sources-to-the-common-data-s...

 

Were you trying to load to an existing entity or a new entity?

 

Since this is still in preview, did this work before for you?

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

redlead3
Level: Powered On

Re: CDS Load Failed Azure DB Data Source - PQOnline Failure

Hi @Mona,

 

This was my first time to attempt this connection. I did follow every step in the guide you provided from 2017. Seems like 2 years in preview is a very long time.

 

For your information, the connection did work in the end. I went back in to view my data connections and it was duplicated multiple times and when I clicked to view the data it asked for credentials again and after this it loaded correctly. I would consider what I experienced a bug. I had already provided my credentials during the set up of the source and the error was not valid.

 

Thank you for your response. Consider my issue resolved, but a bug reported.

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Users online (4,701)