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

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"})

 

 

 

 

 

Need Help

3 Replies

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