Finance | Project Operations, Human Resources, ...

Field 'xxx' must be filled in.; Warning: validateWrite failed on data source 'DS'

(0) Share

Report

Posted on by DAX Dev

Hello,

I have a custom data entity.

When I do the "Export in Excel", I get data correctly.

I wanted to test the publish function. So I added new line in excel and filled all the data correctly. Values are correct (same values I would select on D365 form).

When I save file and click publish I get error message: Field 'xxx' must be filled in.; Warning: validateWrite failed on data source 'DS'.

Field xxx is mandatory on table, this is the referenced field, so the value I use in excel exists already in d365.

What could be the reason? How to understand this issue?

Thanks.

I have the same question (0)

All responses (4)

Answers (0)

Sort by

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

Is it a standard table and standard data entity that you use with Excel? Or a custom one?

Do you have value in field xxx in Excel?

Was this reply helpful? Yes No
DAX Dev 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Nikolaos,

everyhting is custom.

Yes, I have a value in this field in excel.

Is there any possibility to debug this kind of issue?

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

Could you check if your entity key fields match an unique index on your table?

So: does your table have some unique index that has same fields than what you have in your entity key?

Was this reply helpful? Yes No
DAX Dev 2 on at

Like (0)

Report
Copy link

Link copied!

This is the structure:

Main Datasource on entity is "MySubCategoryTable" with unique index SubCategoryId.

Related Datasource is "MyCategoryTable" with CategorId field as unique index (xxx field that I mentioned previously).

On the DataEntity key I have only SubCategoryId field.

So the error comes from the second (related) datasource field.

Was this reply helpful? Yes No