Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

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

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator
      4 years ago

      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.