Data Integration Error Message Challenge

(0) Share

Report

Posted on by Rafael BATISTA 2

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

Categories:

Microsoft Dataverse with Power Apps

errorCDS.PNG

I have the same question (0)

All responses (5)

Answers (0)

v-xida-msft on at

Like (0)

Report

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-to-load-queries-from-Azure/td-p/164540

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

Was this reply helpful? Yes No
Rafael BATISTA 2 8 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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}

Was this reply helpful? Yes No
Rafael BATISTA 2 8 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Mahesh Wankhade 12 on at

Like (0)

Report

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"

Was this reply helpful? Yes No