help with pulling multiple sharepoint libraries into Power BI

[NewPowerBI2025]

Hi all 

Hope someone is able to help me.

I am fairly new to Power BI . I am trying to pull multiple document libraries into a Report. They are all within one SharePoint online site, 

I need to have a slicer on the page which lets you choose from a drop down of the document libraries. The info I'm trying to display is 

Number of Items per selection (number of documents/files in the library/libraries)

total MB size per selection (library)

I have been looking and found different posts that use the SharePoint folder connection, but then I dont seem to have the Storage used information. 

Any help please ?

[Anonymous]

Hi @NewPowerBI2025 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[Anonymous]

Hi @NewPowerBI2025 
I wanted to check if you had the opportunity to review the information provided by @rajendraongole1 . Please feel free to contact us if you have any further questions. If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[Anonymous]

Hi @NewPowerBI2025 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[rajendraongole1]

Hi @NewPowerBI2025 - please refer the below suggestions shared. 

HELP - Power Bi - Pull in multiuple SharePoint Doc... - Microsoft Fabric Community

If you don’t see the Size column, ensure that you enable File Properties in the SharePoint document library settings.Check that the Power BI permissions have access to all document libraries.

Hope this helps.