Forum Discussion

sham_rh's avatar
sham_rh
Frequent Visitor
9 years ago
Solved

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

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.

Dashboards
Reports

2 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    sham_rh

     

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

     

     

    Best Regards,
    Herbert

    • sham_rh's avatar
      sham_rh
      Frequent Visitor
      9 years ago

      Herbert, 

       

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

       

      Shamprasad