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 - you can achieve the same,
Step 1: Connect to SharePoint Online Document Libraries
Get Data > SharePoint Folder
Enter the SharePoint site URL (e.g., https://yoursite.sharepoint.com/sites/yoursite).
Authenticate if needed.
Power BI will pull in all files from the site.
Filter only the document libraries you need using the "Folder Path" column.
Create a new column to extract the library name from the "Folder Path" column
LibraryName = PATHITEM(REPLACE([Folder Path], "https://yoursite.sharepoint.com/sites/yoursite/", ""), 1, "/")
Create Measures for the Visuals based on number of documents
DocumentCount = COUNTROWS('TableName')
Database size
TotalDataSizeMB = SUM('TableName'[Size]) / (1024 * 1024)
% calculation
StorageUsedPercentage =
DIVIDE([TotalDataSizeMB], [TotalSiteStorageMB], 0)
Step 4: Create the Visuals
Card Visual for the document count using [DocumentCount].
Card Visual for the total data size using [TotalDataSizeMB].
Pie Chart showing storage used out of total.
Step 5: Apply Slicer to Visuals
Ensure all visuals are responsive to the slicer selection using Edit Interactions in the Format tab.
Hope this details helps.
Create a report on a SharePoint List in Power BI Desktop - Power BI | Microsoft Learn