Forum Discussion
Entities do not appear in Dataflow when creating Linked Entities
Work around doesnt resolve the issue anymore.
To address the original issue of this thread I used the work around of changing date field formats to text format based on the recent discussions on this and other threads. It worked for me yesterday. Now today, I am trying to create a new dataflow using linked entities and am encountering a new but related issue.
The new issue is as follows:
1. I created a dataflow that combines data from many excel files. After the files are combined (i.e. in the final table, not the transform sample table), there are some steps to add the date.
2. As mentioned, the date field was changed to text format and the table now appears in the list of entities. (yesterday's issue)
3. Now Today's issue is that although the table appears, there is no data in the table when trying to link to this dataflow/entity. I have tried both in PBI Service (creating a new linked entity) as shown in the screen capture, and I have tried in PBI Desktop by "getting data" from the dataflow--both show no data.
4. Surprisingly, when i go to edit the dataflow entity directly, there is preview data shown. Also, when linking to the entitie, the transform sample file does show data.
To summarize, the workaround is enabling the table to show up, but now new issue is that there is no data in the table.
Disregard the issue I mentioned above.
During my various testings to resolve the date field format issue, I turned off the "Enhanced Datflows Compute Engine (preview)" in the premium admin portal. Once I switched it back on and reset the Premium server, the date field work around does work as others have mentioned and the data appears as it should.
How to turn Enhanced Dataflows Compute Engine off without premium? Can't find.
