Get Data process for a SharePoint Online List using Implementation 2.0 missing two needed fields

[Charles_625g]

I have a question on the Power BI get data process for a SharePoint Online List using Implementation 2.0 (still in Beta?).  When pulling in the data using Implementation 2.0, all of the data is present in the Transform Data screen except the Author field (Created By in SharePoint) and the Editor field (Modified By in SharePoint). 

Using Implementation 1.0 there is a field called FieldValueAsText which can be used to select and populate the missing fields; Implementation 2.0 does not have the FieldValueAsText field.  There seems to be no other way to pull in the Author field and the Editor field using Implementation 2.0.

Testing on Implementation 2.0 showed it to be much faster at executing scheduled refresh cycles and so is preferred if all of the required data is brought over to BI.

Is there a workaround enabling Implementation 2.0 to pull in the Author field and the Editor field data from SharePoint? 

[Anonymous]

Hi @Charles_625g ,

Please correct me if I misunderstood.

Do you mean that you can see the Author filed and Editor Filed in Power Query editor page？

Does these two filed are measure in your table?

Best Regards,
Community Support Team _ Caitlyn

[Charles_625g]

Actually, I can only see the Author field and Editor field when using Implementation 1.0, and then only after selecting the two fields in the FieldValueAsText field.   The two fields are critical to the purpose of the reports being created.