Thank you Denis for putting this up. I have zero knowledge on Power Bi but with your video and additional info I have been able to pull the data from multiple sites which is great. However I'm trying to analyze the All_Files table to see if there are duplicates of a file on multiple sites but the results aren't correct and I'm sure I'm going about it the wrong way, how can i achieve this? Thanks,
Yes, you can: - Home Tab > Transform - Under the Queries section: Duplicate "Site_Files-1" query as many times as you ened - Open the new queries in the Advanced editor. Update the "Source = " variable to point to the new site - Open All_Files query in the advanced editor and update this formula to add new Queries: - let Query1 = #"Site_Files-1", Query2 = #"Site_Files-2", Query3 = #"Site_Files-3", ... Query10 = #"Site_Files-10", AppendedQuery = Table.Combine({Query1, Query2, Query3, ..., Query10}) in AppendedQuery
If you don't have too many sites, you can update the query to include all sites you want to target: github.com/Zerg00s/sp-duplicate-files-report#updating-all_files-query
hi thanks for responding, I have around 100 sites. 🥹 I think it will be difficult to add it one by one. Any idea wht is the best option to get data to all sites in our tenant?
This is some great stuff thanks for sharing this is better than majority of 3rd party tools too!
Thank you Denis for putting this up.
I have zero knowledge on Power Bi but with your video and additional info I have been able to pull the data from multiple sites which is great.
However I'm trying to analyze the All_Files table to see if there are duplicates of a file on multiple sites but the results aren't correct and I'm sure I'm going about it the wrong way, how can i achieve this?
Thanks,
That is just Awesome Denis...
The above is using file name and file size, can this be modified to use the file hash?
Allah razı olsun
Can I also add sites 4 5 and 6?
Yes, you can:
- Home Tab > Transform
- Under the Queries section: Duplicate "Site_Files-1" query as many times as you ened
- Open the new queries in the Advanced editor. Update the "Source = " variable to point to the new site
- Open All_Files query in the advanced editor and update this formula to add new Queries:
-
let
Query1 = #"Site_Files-1",
Query2 = #"Site_Files-2",
Query3 = #"Site_Files-3",
...
Query10 = #"Site_Files-10",
AppendedQuery = Table.Combine({Query1, Query2, Query3, ..., Query10})
in
AppendedQuery
Thanks! @@denismolodtsov3879
is it possible to get all Sharepoint site not only specific site?
If you don't have too many sites, you can update the query to include all sites you want to target: github.com/Zerg00s/sp-duplicate-files-report#updating-all_files-query
hi thanks for responding, I have around 100 sites. 🥹 I think it will be difficult to add it one by one. Any idea wht is the best option to get data to all sites in our tenant?
great tip!
Glad you think so!