Facing problem while importing data from Sharepoint List ?

[suvechha]

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 but when I am loading the data from sharepoint List I saw the field Requestor .

How to show the Requestor value in my Power BI Report.

Please kindly assist.

[AllisonKennedy]

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.

[amitchandak · Accepted solution]

@suvechha , refer if this can help

https://whitepages.unlimitedviz.com/2018/01/using-power-bi-to-report-on-person-fields-in-sharepoint/