I have created two Data Entities for standard tables i.e Salesline and CustinvoiceTrans. The records aren't populated in the Data Entity. Even exported the Entity and checked. Found there is no record in the staging table.
I need to use these two tables for Power BI. Thus created entities for accessing them on Power BI.
(Screenshot below - Accessed the Entity in Power BI and found 0 records)
Any suggestions, as to why the table records aren't populating in the Entity?
Do you see any error ? Did you check execution log ?
Check the execution log to find out error if anything occurred. Also check the Primary company context on the entity properties. If you see it set to anything, clear it and try.
Is this a development environment? If so, did you synchronize the database? Can you tell how you created the entities? Are you in the correct company?
Its a development environment, I am in the correct company. Done a full build and DB sync.
I even exported the entity, the staging table has no records.
Data entity creation steps
1. Add new item- data entity
2. Add primary data source
3. Click next, finish
Can you check if the underlying tables has data ? Does your entity contains only one datasource ?
Yes the table has data. It is salesline table.
And yes, my entity contain only 1 data source.
Did you try to create a data management project and export your entity to file? Does the file contain any records? Staging might be empty if you chose to "Skip staging" in the data management project settings.
Also are you running it in a context of a company where data exist in the table? For example if you run it in DAT it will be empty.
Can you check if the staging table has data or no
Staging is empty and even the downloaded file is empty. And I am in appropriate company.
Not in DAT.
I even tried clearing the primary context data in entity property. It dint work though
Then you need to compare to standard entities which work (do they) and try to find the difference.
I found there isn't any difference. Still, the issue exists.
No records in the Sales line entity.
Did you try exporting standard entity?
Yes, there are records in standard entities.
I have exported and checked it already.
Then the only possible explanation is in your entity. Do you agree?
Are you sure you don't have any child data sources? If you have date effective tables, such as address, in a child data source, and it's outer joined, it will export only those records where the child data source date is valid as of today.
Can you check if the Data Management is enabled and if it Is Public in the entity properties?
Business Applications communities