You’re offline. This is a read only version of the page.
Announcements
56
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?
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.
Share
Report
All responses (
Answers (
