cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Data Integration Error Message Challenge

Hello everybody,

 

We are trying to use CDS and Data Integration Projects to integrate data between D365 FinOps and D365 CE. applications.

We have implemented a flow from FinOps to D365 where we try to push a list of records. On the advanced query, we merged the FinOps table with a column containing the Guid from the CRM. This colum has been extracted using the connection to the D365 CE with SimpleODataFeed.

We have the following error message : 

 

The powerquery job failed with error: Challenge ChallengeType:Resource, ChallengeDataSource:{"Kind":"Web","Path":"https://******.crm4.dynamics.com/api/data/v9.0/sg_countries?$select=sg_code,%20sg_countryid,%20sg_name,%20statecode,%20statuscode&$orderby=sg_code%20desc","NormalizedPath":"https://*****.crm4.dynamics.com/api/data/v9.0/sg_countries","IsDefaultForKind":false}

It looks like the Power Query Job failed when trying to connect to the D365 API.

 

Any help is appreciated

Regards,

Rafael

5 REPLIES 5
Highlighted
Community Support
Community Support

Re: Data Integration Error Message Challenge

Hi @rafaelb

Do you want to make a Data Integration between Dynamics FinOps and and Dynamics 365 CE within CDS?

The user @faridjalal  and @Sonia_Sarkar has faced simiar issue with you, please check the following threads:

https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Data-Integration-Error-while-trying...

https://powerusers.microsoft.com/t5/General-Discussion/Getting-error-in-Power-Query/td-p/100684

In addition, there is a region limitation in Data Integration in PowerApps. Currently, Data Integration is only supporeted within  Australia, Canada, North America, Europe and Asia. Please check if the resgion your PowerApps Environment belongs to is within these available Regions.

Please also consider take a try to clear cache of your browser, then remove/delete the original connection to your Dynamics 365 FinOps service and re-create a connection to it, check if the issue is solved.

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: Data Integration Error Message Challenge

Hello Kris,

Thank you for your support. I checked the links you provided, but any of them is relevant since I faced this error today and all the Hotfixes have been deployed in the previous articles.
Data Integration limitation is compatible since I am working from Europe Region.

I also have recreated the connection to FinOps and cleared the cache, but nothings happens. The errors remains the same.

 

 

Any other has a solution ?

Regards,

Rafael

Highlighted
Anonymous
Not applicable

Re: Data Integration Error Message Challenge

Did you manage to fix this issue?

 

I am expeciering the same error merging data from F&O Source with a table resulting from the fSimpleODataFeed function.

I get the following error during execution:

 

The powerquery job failed with error: Challenge ChallengeType:Resource, ChallengeDataSource:{"Kind":"Web","Path":"https://{server}.crm4.dynamics.com/api/data/v9.0/pricelevels?$filter=name%20eq%20'Base%20Sales%20Price%20List%20123","NormalizedPath":"https://{server}.crm4.dynamics.com/api/data/v9.0/pricelevels","IsDefaultForKind":false}

Highlighted
New Member

Re: Data Integration Error Message Challenge

Hello,

 

Microsoft Support provide me some answers. The process we are trying to build right now is not supported.

In other words, it's not possible to build and andvanced query starting from environnement table and apply a request to retrieve another table from other environnements.


However, if I got back to my main technical need, I figured out that I don't need to manipulate the Guids myself and merge the tables manually. You just need in CDS platform to carefully set your primary key on the list of entites. These primary key are the key attributes for UPSERT rules. You will then fin the in the list of available fields when mapping attributes. (Syntax will be something like ParentAttribute.ChildAttributePrimaryKey (you migh need to click on "Refresh entities" after setting the primary keys.)

Highlighted
Frequent Visitor

Re: Data Integration Error Message Challenge

Hi Experts,

Does that mean in data integrator we can't pull data from FinOps using Adavanced Query ODATA option ?

We are trying to push CE Address to FinOps CustomerAddress table using data integrator.

For upert scenario we need to get latest Effective Date for address from FinOps CustomerAddress table.

i was planning to use Advanced query Get Data option to get latest Address from FinOps and then join it with CE table to get latest Effective date.

 

However Advanced Query Get Data option is throwing me below errror

failed to update M query for b5b368e0-df37-11e9-b900-95f6e583c62b-Address-Address1. - PQOnline failure - The powerquery job failed with error: Challenge ChallengeType:Resource, ChallengeDataSource:{"Kind":"OData","Path"

 

 

 

 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (9,260)