Data Entity has no data while default table has data

Like (0) Share

Report

Posted on 20 Apr 2023 05:51:23 by Roohan Amir - BI De...

Hi
I'm currently working of D365 FO and created an Entity from a default table suing Data Entity Wizard. I build it and synchronized the database. However, Data Entity shows no data while the default table has data in it.

What could be the possible cause and how to troubleshoot it?

All responses (14)

Answers (0)

GirishS 27,823 Moderator on 20 Apr 2023 at 07:29:01

Like (0)

Report

RE: D365 FO Data Entity has no data while default table has data

Default table in the sense means are you referring to table browser?

Does that table has any relation with other table.

If yes, then check whether that table is added under datasource node of data entity.

Thanks,

Girish S.
Bharani Preetham Pe... 3,622 Moderator on 20 Apr 2023 at 07:27:07

Like (0)

Report

RE: D365 FO Data Entity has no data while default table has data

If you see my earlier response, please send snaps of

- properties

- Expand the ds at entity level
Roohan Amir - BI De... 25 on 20 Apr 2023 at 07:24:51

Like (0)

Report

RE: D365 FO Data Entity has no data while default table has data

SSMS return no data in Data Entity while returns data in default table
Roohan Amir - BI De... 25 on 20 Apr 2023 at 07:22:06

Like (0)

Report

RE: D365 FO Data Entity has no data while default table has data

I added the data source from Data Entity Wizard
Bharani Preetham Pe... 3,622 Moderator on 20 Apr 2023 at 07:12:17

Like (0)

Report

RE: D365 FO Data Entity has no data while default table has data

No data means, check the entity in SSMS by firing an SQL query. If it is not showing then see the properties of the datasource. Check the ranges.

Also please send the properties and how the datasource is added.
Bharani Preetham Pe... 3,622 Moderator on 20 Apr 2023 at 07:09:47

Like (0)

Report

RE: D365 FO Data Entity has no data while default table has data

Can you show us the relations what you have added?
Roohan Amir - BI De... 25 on 20 Apr 2023 at 07:05:34

Like (0)

Report

RE: D365 FO Data Entity has no data while default table has data

No data
Roohan Amir - BI De... 25 on 20 Apr 2023 at 07:05:14

Like (0)

Report

RE: D365 FO Data Entity has no data while default table has data

My data entity has only ONE source.

I tried deleting the artifact, I tried creating new entity. No luck
Mohit Rampal 12,556 Moderator on 20 Apr 2023 at 06:38:46

Like (0)

Report

RE: D365 FO Data Entity has no data while default table has data

Hi Roohan, If your table has data and Data entity is not displaying records in Sql server then there might be issue in data entity. Have you set any range on the data entity or Datasources. Does your data entity have multiple datasources.
GirishS 27,823 Moderator on 20 Apr 2023 at 06:17:20

Like (0)

Report

RE: D365 FO Data Entity has no data while default table has data

Refer to the below blog.

https://gfeaxblog.wordpress.com/2017/10/09/o365-how-to-exportimport-data-through-data-management-framework-dimf/

Thanks,

Girish S.