Forum Discussion
Solved
Slow Loading record field to Power Bi
Hi, I have a Power Bi file which reads the data from a sharepoint list. The sharepoint list has fields as people picker which basically is a record field storing name/address/email/phone/..... Upl...
Please see this video for a different way to bring in SharePoint List data, but much faster.
Get SharePoint List Data with Power BI ... Fast - YouTube
Pat
Thanks, The vidoe is really helpfull. It recommends to use version2 list connection which looks to be much faster. One issue which does not explain in the video is that, when I extract data with V2, the name column will change to type "list" rather than being the record. Then PBI does not allow to expnad the "list" column to extract title.
V1 the existing slow extract:
V2
How can I expand this column?
Not sure how. But, now I can see the expand function.