Trouble with Product Entity in my DataFlow

(0) Share

Report

Posted on by crham

We want to get products from our quoting software SQL Database into FS365.

I chose to go with a DataFlow but have run across a snag.

To test further I backed all the way up to only map the most minimal required columns:

Product Name

Product ID

Default Unit

Unit Group

Decimals Support

As per the wisdom from the previous posts I went to the Unit table and created a Key for the Name field, as well as the Unit Group table.

I made sure the names of each matched an existing Unit and Unit Group in FS365.

However, 0 of my 788 records "imported"...of course no errors to troubleshoot anything.

1. How do you troubleshoot something like this?

2. What am I missing?

I did make sure the dataflow would work by creating a copy and instead of loading it into an existing table I chose to load it to a new table and all the data successfully went to that table.

All responses (1)

Answers (0)

crham 54 on at

Like (0)

Report

Re: Trouble with Product Entity in my DataFlow

Trying to import products into D365. However they are not being imported into existing Product table. I can import them into a new table but that was just for testing.

I am using a DataFlow so yes it's using Power Query and no it's not using Power BI.

This issue is the lookup with the Product Unit Group and Default Unit. I know from other posts I needed to first make a Key on those tables and did so, but still the records are not importing and of course there's no output/error messages to read in order to troubleshoot why not.