Why add table does not work in data connector (Excel AddIn)

(0) Share

Report

Posted on by Kumar_Sat

1,290

I see there is an option to add table in data connector (Excel AddIn in D365), however, it does not work (Excel addin >> Design) for any table. Why? Also, if it does not work, why it is even available?

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Sukrut Parab 71,741 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can add a new tab in excel and add new table and its fields and get the data . When you do add table it shows list of entities available with in system , you can use it to get data from those entities. See below image one tab shows customer groups and other tab is for customer postal address.

Was this reply helpful? Yes No
Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Kumar,

What do you mean by not working? Get other error tips?

As Sukrut mentioned, it will show the entity data source when you click on it

When there is a red mark behind the data source field, you cannot add it.

But, You can add other fields, click "refresh" to get the data after adding.

Was this reply helpful? Yes No
Verified answer

Rahul Mohta 21,046 on at

Like (0)

Report
Copy link

Link copied!

it depends on the number of tables the OData dependent data entity utilizes, if it's one one then there is nothing to add table

you could possible try with customers and vendors entity to add data but probably not party postal address

Was this reply helpful? Yes No