cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rafaelb
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
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.
rafaelb
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

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}

rafaelb
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
maheshw
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
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Attending MBAS? Claim your badge

Attending MBAS? Claim your badge

Whether you’re streaming the digital event live, or watching on-demand, claim your attendee badge to sport on your profile.

‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We're launching a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Emergency Response & Monitoring Solution

Emergency Response & Monitoring Solution

Microsoft has created a regional government emergency response and monitoring solution that is built on Power Apps and Power BI.

Users online (6,053)