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.
MS Product Team are aware of the issue with Dataflow entities not appearing in Desktop browser. They are planning on implementing a fix by the end of the week.
See thread:
I have had other issues with dataflows this week, and their tech team suggested I wait until next Monday and check again then. If there are issues remaining next week then submit a support ticket.
My issue is entities not appearing in Desktop or Service...Microsoft Support said the bug has been identified and the fix would take 4 weeks.
Trying to see if I can get them to find out more information from the product team about what's causing the issue--so maybe I can find a workaround instead of waiting a month to share my dataflows.
jeffshieldsdev the attached thread as supplied by rargyle contains all the information required to workaround the issue. What you have described is consistent with everyone's issue (well not Doodle's new issue). Any entity containing a Date field is now being stored as "Unclassified". This results in new and existing Entity not appearing in the
Workaround:
Edit your dataflow, change all your Date fields to a data type of DateTime or Text, then your entities will appear in both the Service and Deskop. Change the data type field in the Desktop to back "Date" as required for relationships and visuals.
