HELP - Power Bi - Pull in multiuple SharePoint Document Libraries with Data Slicer on report

[NewPowerBI2025]

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 choose 1/multiple/all libraires

3. Then 3 visuals that show based on the slicer selection  - 1. Number of documents   2. Total Data Size per Selection and a pie chart that shows storage used out of the total for the site. 

I am very new to Power Bi, but learning , but I have this requirement to try and resolve. Thank you so much for any advice and or pointers 

[v-sgandrathi]

Hi @NewPowerBI2025,

Thank you @Akash_Varuna and @rajendraongole1 for your response regarding the query.

Has your issue been resolved?If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!

[v-sgandrathi]

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.

[v-sgandrathi]

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.

[Akash_Varuna · Accepted solution]

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

[rajendraongole1]

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