Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Have you tried to click the expand button in Query Editor as below?
Best Regards,
Herbert
Herbert,
Thanks a lot, I am able to get the values properly now.
Shamprasad
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |