Forum Discussion

siumui's avatar
siumui
Icon for Helper I rankHelper I
5 years ago
Solved

Need help to connect Power BI to SharePoint List View

Hello all,   I created a View in SharePoint List where it gives me only last 30 days data.  The normal list contains whole year of data which I don't need for it will be a long list.  I only need l...
Need Help
  • Nerdy_Julie's avatar
    Nerdy_Julie
    5 years ago

    Hi siumui, 

     When you shape the data in Power Query (filter, remove columns, etc.) it reduces the file size.  Here's an example.

siumui's avatar
siumui
Icon for Helper I rankHelper I
5 years ago

Hi Nerdy_Julie ,

 

Yes, the default view has all the columns I need and of course, there are hundreds thousands of records.

 

I tried your method, it works.  But I have a question.  So when it connects to the source, it still pull how ever many records there are in SharePoint list, correct?  If there are 200,000 records, Power BI would still pull all 200,000 records first, then the step to filter for the last 30 days will come next, right?

 

My concern is performance.  To pull all records from SharePoint list it's just...a huge volume of data and it would be slow and time consuming - that's my thought.

Nerdy_Julie's avatar
Nerdy_Julie
Regular Visitor
5 years ago

Hi siumui, 

 When you shape the data in Power Query (filter, remove columns, etc.) it reduces the file size.  Here's an example.