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

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 Team
Community Support Team

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
Level: Powered On

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

hcidario
Level: Power Up

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
rafaelb
Level: Powered On

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

maheshw
Level: Powered On

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
thirdimage

Power Apps Super User Class of 2020

Check it out!

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

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)
Users online (4,757)