Forum Discussion

amirghaderi's avatar
amirghaderi
Helper IV
5 years ago
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...
Need Help
amirghaderi's avatar
amirghaderi
Helper IV
5 years ago

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?

 

 

  • amirghaderi's avatar
    amirghaderi
    Helper IV
    5 years ago

    Not sure how. But, now I can see the expand function.