Forum Discussion

Jack95's avatar
Jack95
New Member
1 year ago
Solved

Power Query SharePoint Connections Refresh Speeds

Hi,   I have a number of queries connected to SharePoint - the queries are purely to extract metadata on the Site itself - permissions, record count, date fields, etc. - I'm not trying to extract d...
Need Help
  • MasonMA's avatar
    MasonMA
    1 year ago

    Jack95 

     

    Hi, the best approach would be use filtering in the Source step or as early as possible to avoid loading full content of lists if you're only interested in metadata like item count, permissions, or last modified date.

     

    There's official Microsoft documentation recommending filtering as early as possible in Power Query. This means placing your Table.SelectRows(...) filters immediately after the data source step so that fewer rows are pulled into Power BI, reducing memory and processing time.

     

    Best practices when working with Power Query - Power Query | Microsoft Learn

v-achippa's avatar
v-achippa
Community Support
1 year ago

Hi Jack95,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you MasonMA for the prompt response.

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user resolved your issue? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    Hi @Jack95,

     

    We wanted to kindly follow up to check if the solution provided by the user resolved your issue? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa