Forum Discussion
Solved
HELP - Power Bi - Pull in multiuple SharePoint Document Libraries with Data Slicer on report
I am desperate to get an answer to this. I have a requirement to 1. Pull in multiple SharePoint Online Document Libraires from one site into one report 2. a Slicer on the report that lets you ...
Hi NewPowerBI2025 You Could try these
- Combine Libraries: Use Power Query to connect to multiple SharePoint libraries and append their data into a single table. Include a column identifying the library source.Get Data -> SharePoint Folder -> Give URL -> Authenticate
- Create Slicer: Add the library source column to a slicer for filtering.
- Visuals: Build visuals:
- Bar chart for document count (Count of documents).
- Column chart for total size (Sum of file sizes).
- Pie chart showing storage per library (Storage used vs. site total).
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
Hi NewPowerBI2025 You Could try these
- Combine Libraries: Use Power Query to connect to multiple SharePoint libraries and append their data into a single table. Include a column identifying the library source.Get Data -> SharePoint Folder -> Give URL -> Authenticate
- Create Slicer: Add the library source column to a slicer for filtering.
- Visuals: Build visuals:
- Bar chart for document count (Count of documents).
- Column chart for total size (Sum of file sizes).
- Pie chart showing storage per library (Storage used vs. site total).
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance