cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

Trouble with Product Entity in my DataFlow

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.
 

 

2 REPLIES 2
v-kkf-msft
Community Support
Community Support

Hi @Syndicate_Admin ,

 

I am not sure if I understood your question correctly. Are you using Power Query to connect to the SQL database and can't import data from the source?
Or have you successfully created a dataflow, but are not importing any data when connecting to this dataflow using Power BI Desktop?

 

Best Regards,
Winniz

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.

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors