Forum Discussion
HELP - Power Bi - Pull in multiuple SharePoint Document Libraries with Data Slicer on report
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,
Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If you've already resolved the issue, you can mark the helpful reply as a "solution" so others know that the question has been answered and help other people in the community. Thank you again for your cooperation!
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you.
Hi NewPowerBI2025,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you.