Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a folders and files on SharePoint , need a way to iterate through all folders for files, based on the name format display the count of files, and last modified by details in power bi. When we pull the data into power bi from SharePoint folder then there are multiple files with different file format and due to that unable to combine the files so without combining the files how can we calculate the number of folders and there sub folders and files with hierarchy.
You can use the OData connector instead of the SharePoint folder connector to do this. I did a video on how to use OData to collect info about files in SharePoint here if that helps: https://youtu.be/yeIQ9jKln_I
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
100 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
104 | |
85 | |
73 |