Forum Discussion

Doodle's avatar
Doodle
Icon for Advocate II rankAdvocate 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
Icon for Solution Sage rankSolution 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
Icon for Advocate II rankAdvocate 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.