Slow Loading record field to Power Bi

[amirghaderi]

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/..... 

Uplaoding these records takes  huge amount of time and I am sure the upload process will crash soon. I am trying to find a way that when the data get read from sharepoint list for those fileds, it only loads the name to Power Bi rather than everything.

I have only been able to load the full data and then after full load remove the unnecessary data. But, I think there should be a way that at navigation stage to force the query to only load speific data of record field.

Not sure, if anybody has got the souloution or has experienced this issue.

This is the command which makings the refresh very slow: this basicaly takes the Title section of Record and bring as as column. without this command it is quick.

#"Expanded CTRSubmissionRequester1" = Table.ExpandRecordColumn(#"Removed Columns", "CTRSubmissionRequester", {"Title"}, {"CTRSubmissionRequester.Title"})

[mahoneypat · Accepted solution]

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

[amirghaderi]

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]

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