SharePoint online task list data not showing value for assigned to field.

[sham_rh]

I am trying to fetch data from Sharepoint Online tasklist and values for assigned to field are getting displayed as list and not displaying actual values and also for lookup column id is getting displayed instead of value. 

How can we get the proper values. 

I am using getdata-->Online Services-->SharPoint Online List for getting data in Power BI desktop.

[v-haibl-msft · Accepted solution]

@sham_rh

Have you tried to click the expand button in Query Editor as below?

Best Regards,
Herbert

[sham_rh]

Herbert, 

Thanks a lot, I am able to get the values properly now.

Shamprasad