One Drive usage over time

%3CLINGO-SUB%20id%3D%22lingo-sub-816653%22%20slang%3D%22en-US%22%3EOne%20Drive%20usage%20over%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-816653%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20need%20to%20produce%20a%20report%20around%20One%20Drive%20usage%20over%20the%20past%20year%2C%20but%20referring%20to%20a%20subset%20of%20users%2C%20depts%20and%20offices%20around%20our%20Org.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20build%20in%20O365%20reports%20only%20go%20back%20180%20days%20and%20you%20cannot%20filter%20these%20reports%20based%20on%20location%20or%20Azure%20Attributes%20like%20Office%2FLocation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20achieved%20the%20above%20with%20PowerBi%2C%20or%20used%20another%20means%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-816653%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOneDrive%20for%20Business%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-816759%22%20slang%3D%22en-US%22%3ERe%3A%20One%20Drive%20usage%20over%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-816759%22%20slang%3D%22en-US%22%3EWhat%20about%20using%20the%20Microsoft%20365%20Usage%20Analytics%20Power%20BI%20content%20pack%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fadmin%2Fusage-analytics%2Fusage-analytics%3Fview%3Do365-worldwide%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fadmin%2Fusage-analytics%2Fusage-analytics%3Fview%3Do365-worldwide%3C%2FA%3E%3CBR%20%2F%3EIn%20regards%20of%20the%20180%20days%20period%2C%20this%20is%20a%20limitation%20you%20will%20have%20to%20deal%20with%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-816776%22%20slang%3D%22en-US%22%3ERe%3A%20One%20Drive%20usage%20over%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-816776%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Juan%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20content%20pack%20only%20shows%20data%20for%20the%20past%20month%20and%20there%20is%20no%20way%20of%20filtering%20out%20data%20for%20historical%20one%20drive%20usage%20based%20against%20an%20office%20location%20pulled%20in%20from%20azure%2C%20even%20though%20I%20relationships%20between%20tables%20are%20created%20the%20figures%20within%20the%20content%20pack%20show%20%22total%22%20events%20for%20that%20month.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20correct%20me%20if%20I'm%20wrong!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ERobbie%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi there,

 

I have the need to produce a report around One Drive usage over the past year, but referring to a subset of users, depts and offices around our Org.

 

The build in O365 reports only go back 180 days and you cannot filter these reports based on location or Azure Attributes like Office/Location.

 

Has anyone achieved the above with PowerBi, or used another means?

 

Thanks

2 Replies
Highlighted
What about using the Microsoft 365 Usage Analytics Power BI content pack: https://docs.microsoft.com/en-us/office365/admin/usage-analytics/usage-analytics?view=o365-worldwide
In regards of the 180 days period, this is a limitation you will have to deal with
Highlighted

Hi Juan,

 

the content pack only shows data for the past month and there is no way of filtering out data for historical one drive usage based against an office location pulled in from azure, even though I relationships between tables are created the figures within the content pack show "total" events for that month.

 

Please correct me if I'm wrong!

 

Thanks

Robbie