Finance | Project Operations, Human Resources, ...

Data Entity has no data while default table has data

(0) Share

Report

Posted on 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?

I have the same question (0)

All responses (14)

Answers (0)

Suggested answer

GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Roohan,

Expand the DataSource node of the table you have created data entity for. See whether records exist in the related datasource which was added automatically from the table relations.

Also, how you are verifying that entity has no data?

Thanks,

Girish S.

Was this reply helpful? Yes No
Roohan Amir - BI De... 25 on at

Like (0)

Report
Copy link

Link copied!

Yes. Records exist

I check my executing a query for Default Table and then for my Data Entry in SQL Server

Was this reply helpful? Yes No
GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

Data entity is mainly used for importing and exporting data through excel using DMF or open in excel functionality, OData and other integration scenarios.

So, use the DMF to check whether the record exist for the entity you created.

Thanks,

Girish S,

Was this reply helpful? Yes No
Roohan Amir - BI De... 25 on at

Like (0)

Report
Copy link

Link copied!

Can you walk me through the process?

Was this reply helpful? Yes No
GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Roohan Amir - BI De... 25 on at

Like (0)

Report
Copy link

Link copied!

My data entity has only ONE source.

I tried deleting the artifact, I tried creating new entity. No luck

Was this reply helpful? Yes No
Roohan Amir - BI De... 25 on at

Like (0)

Report
Copy link

Link copied!

No data

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you show us the relations what you have added?

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No