Forum Discussion

Doodle's avatar
Doodle
Advocate II
6 years ago

Entities do not appear in Dataflow when creating Linked Entities

Hi,   I created a data query in PBI Desktop. The query combines multiple files and so during that process, PBI created the helper files (sample file, parameter, transform sample file, and transform...
Need Help
jeffshieldsdev's avatar
jeffshieldsdev
Solution Sage
6 years ago

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.

jcullum's avatar
jcullum
Advocate II
6 years ago

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.

  • jeffshieldsdev's avatar
    jeffshieldsdev
    Solution Sage
    6 years ago

    Right now I'm getting a 500 error trying to save dataflows--so I can't test now.

     

    I don't have any Dates but a lot of DateTimes...I'll change them all to Text and see what happens.  Thanks for the suggestion.

     

     

    • jcullum's avatar
      jcullum
      Advocate II
      6 years ago

      jeffshieldsdev That sounds new.  DateTime fields were working fine.  I am not sure the change to text is going to fix your problem.  I have been using a mixture of DateTime and Text.

       

      In the Edit Dataflow web UI, expand the Entities (not to be confused with Editing the Entities) and make sure none of the fields are appearing as "Unclassified".  Any that are you will need to fix by editing the entities.

       

      As an aside.

      I get a 500 error if I use the Web UI for the  sharepoint.files connector.  For some reason the UI doesn't include the [ApiVersion = 15] parameter.  I have to use the advanced editor and manually add that into the connector.  I have asked my internal team to raise that issue with MS also.

       

      Good luck with it all.

      • venal's avatar
        venal
        Memorable Member
        6 years ago

        I heard that it is already escalated to the Product Group(PG) Team for their assistance and next update would be this weekend.

         

        Please refer the support page for further updates from PG Team.

        https://powerbi.microsoft.com/en-us/support/

         

        Data Flow Current Issues:-

         

        Power BI Customers who are using Dataflows may see scheduled refreshes not processed. As a workaround, customers can perform a manual refresh. Engineers are working on a fix and will provide an ETA soon

         

        Customers creating a new Dataflow from the Power BI service will see the default setting "Allow combining data from multiple sources" set to true instead of false. As a workaround, customers can uncheck the setting. Engineers are working on a fix and expect it to be deployed by end-of-day 11/22/2019.

         

        One more Issue

        Data Flow Entities are missing while loading it from Power BI Desktop.

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more
        If this post was helpful may I ask you to mark it as solution and click on thumb symbol?