Forum Discussion
Sharepoint online list - missing fields
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!
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
3 Replies
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)
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
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
