Need help to connect Power BI to SharePoint List View

[siumui]

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 last 30 days data to work with so I created a view that house last 30 days data.  Is it possible to connect to SharePoint List View?  I tried but the Power BI only display all the list names, it doesn't display any view name.  Is there a way to make this possible?

Thank you for all your help.  Have a wonderful day.

[Nerdy_Julie]

The default view has all of the columns you want, just too many rows? You can shape the data in Power Query to  only show the last 30 days.  This can be done without code, instructions in screenshot below.

Hope this helps!

[siumui]

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 · Accepted solution]

Hi @siumui, 

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

[mahoneypat]

If that view is the Default view, you can use the 2.0 version of the SharePoint connector and choose Default view.

FYI too that if you need to pull the full list faster and then filter it down, you can see this video.

Get SharePoint List Data with Power BI ... Fast - YouTube

Pat

[siumui]

Hi @mahoneypat ,

That view is not a default view :(.

I will view your video link.  I'm crossing fingers if there is a way around it.  Thank you.