Forum Discussion
suvechha
5 years agoHelper IV
Facing problem while importing data from Sharepoint List ?
Hi there, How to get the Record from the table fetched from Sharepoint List ? Here is the screenshot , I need to reflect the Requestor in my report. But it is not available in my Power bi Apps ...
- 5 years ago
suvechha , refer if this can help
https://whitepages.unlimitedviz.com/2018/01/using-power-bi-to-report-on-person-fields-in-sharepoint/
AllisonKennedy
5 years agoCommunity Champion
Is Requestor a Choice or Lookup column in SharePoint?
You should have access to the column when you click transform in the screenshot you posted, but since it is a Record you will have to click the two arrows at the column heading to expand the values in that column. Depending on what the raw SharePoint list looks like you'll see different options here.
You should have access to the column when you click transform in the screenshot you posted, but since it is a Record you will have to click the two arrows at the column heading to expand the values in that column. Depending on what the raw SharePoint list looks like you'll see different options here.