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

CDS Data Integration Error

Data Intergration was working but when I changed the friendly name of our enviroment, (We are part of a much larger org and the smaller companies within are creating their own enviroments) I started to get this error.

 

2018-10-18_16-54-38.png

 

Then the text below:

section Section1;
shared vw_WorkOrders = let
Source = Sql.Database("**ServerName**", "IME"),
Navigation = Source{[Schema = "dbo", Item = "vw_WorkOrders"]}[Data],
#"Changed column type" = Table.TransformColumnTypes(Navigation, {{"DocumentNo", type text}}),
#"Remove other columns" = Table.SelectColumns(#"Changed column type", {"DocumentNo", "DocumentDesc", "StatusCode", "BusinessUnit"})
in
#"Remove other columns";

 

**ServerName** is me replacing the SQL Server name for just this post. It does have it correct in the error text however.

 

This enviroment is in the US and is set to Production. This is activly effecting my ability to keep look up fields within the CDS up to date. I've had to fall back to a manual Excel File upload to the Entities which works fine. However, I would like to get this automated again.

 

 

EDIT: In trying to re-run the project after it was created. I received the following error.

 

Load to Common Data Service failed. Details: 
DataPartition imelect for CDS is not valid, Valid DataPartitions are org2e2b95ac. 
. (Job ID: 543b9311-055c-4582-a4a4-c0361d312fb7)

 

(So do I need to change the name from imelect back to org2e2b95ac?)

Helpful resources

Announcements
thirdimage

Power Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 161 members 5,560 guests
Please welcome our newest community members: