Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
As an audit requirment tasked to me, i need to generate a list of all the folders within a document library, the sub folders and whether they have any items (or count of how many items exist in that folder)
I can connect to the site > access the folders but it is only giving me a list of the folders where a file exists. Ideally, what i want to produce is a report showing:
Folder name
Sub Folder Name
Items in Sub Folder
Not sure if this is possible but if someone does know ny help would be greatly appreciated
Thanks
Solved! Go to Solution.
Hi @SteveKWWHA,
According to your description, I think folder connector should suitable for your requirements(get detail information of a specific path and its child)but it only works on 'absolute path' and does not compatible with dynamic web URL.
For this scenario, I'd like to suggest you to use external tools(e.g. PowerShell or programming language) to export detail SharePoint folder contents and save to local file, then you can use power bi to get data from that file.
In addition, you can also try to use power query to invoke python code with iterator function to looping detail contents of a directory.
Regards,
Xiaoxin Sheng
Hi @SteveKWWHA,
According to your description, I think folder connector should suitable for your requirements(get detail information of a specific path and its child)but it only works on 'absolute path' and does not compatible with dynamic web URL.
For this scenario, I'd like to suggest you to use external tools(e.g. PowerShell or programming language) to export detail SharePoint folder contents and save to local file, then you can use power bi to get data from that file.
In addition, you can also try to use power query to invoke python code with iterator function to looping detail contents of a directory.
Regards,
Xiaoxin Sheng
Hi @SteveKWWHA ,
I don't think Power BI alone can do that, but I am aware that there is a way of achieving that using PowerShell. I found this article (link below), which seems to describe how to achieve what you are looking for, but I must admit I don't know much about PowerShell.
Best,
Tom
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |