PowerBi get data from multiple site collections

%3CLINGO-SUB%20id%3D%22lingo-sub-3045605%22%20slang%3D%22en-US%22%3EPowerBi%20get%20data%20from%20multiple%20site%20collections%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3045605%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3CBR%20%2F%3EThere%20is%20a%20requirement%20to%20produce%20a%20PowerBi%20report%20%2F%20dashboard%20but%20gather%20information%20from%20multiple%20site%20collections.%3CBR%20%2F%3EThe%20other%20requirement%20is%20that%20these%20site%20collections%20can%20grow%20and%20the%20url's%20of%20the%20site%20are%20unkown%20until%20the%20site%20is%20created.%3C%2FP%3E%3CP%3EThe%20sites%20will%20contain%20the%20same%20list%20and%20columns.%3CBR%20%2F%3E%3CBR%20%2F%3EIdeally%2C%20PowerBi%20should%20be%20able%20to%20slice%20and%20dice%20the%20data%20from%20various%20sites.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3045605%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDevelopment%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hi,
There is a requirement to produce a PowerBi report / dashboard but rather than getting information from a single site, their is a need to gather information from multiple site collections.


The other requirement is that these site collections can grow and the url's of the site are unknown until the site is created (all sites to be reported on will have the same pre-fixed characters though)

The sites will contain the same list and columns.

Ideally, PowerBi should be able to slice and dice the data from various sites.

Is this possible?

1 Reply
It is possible to do it and there are a couple of approaches that can be used. The biggest issue I see is becoming aware of the new site collection. Do you have a process that is logging the creation some place?
We support Ukraine and condemn war. Push Russian government to act against war. Be brave, vocal and show your support to Ukraine. Follow the latest news HERE