Sharepoint online list - missing fields

[ocervera]

Hello,

I'm getting data from a sharepoint online list but the standard fields "created by" and "modified by" don't come with the model.

They are quite useful because it is important to know who has inserted an item. It is weird because if I importe the same list from Ms Access those fields are available, althouh hidden by default.

If anyone can help about how to get them in PowerBI I'd appreciate it.

Thanks!

[trebgatte]

To all,

I created a video that walks you through the SharePoint List connection process, shows you the most common issues you'll face, and how to address them. I also demonstrate how to use FieldValuesAsText. I hope you find this helpful. https://marqueeinsights.com/how-to-data-mine-a-sharepoint-list-with-power-bi/

Thanks!

Treb Gatte, Data Platform MVP (Power BI)

[v-shex-msft]

Hi @ocervera ,

You can use web connector with sharepoint rest api, it will get all sharepoint fields.

Get to know the SharePoint REST service

Pull data from a REST API Authentication

Regards,

Xiaoxin Sheng

[ocervera · Accepted solution]

Thank you very much,

I've just found another solution. You just have to expand the field "FielsdValuesAsText" and a lot of extra fields come up! The created by is one of them

Best regards