Microsoft 365 usage analytics older than 12 month data

[pjuvalainen]

Hello

Microsoft 365 usage analytics documentation says that it is possible only to view data from of the last 12 months. Is it possible to get older data? Is it possible to store data to database?

[ibarrau · Accepted solution]

Hi. I would say no you can get older data. If you plan to analyze historic data you can store the data in a DB or DataLake to build your own history. You can build an ETL to take the data and store it somewhere at Azure.

I hope that helps,

[pjuvalainen]

Thank you for your reply.  Are there any examples or known solutions how to extract 356 data and load it to azure blob strorage?  I am little bit new with these, so I am not famialiar with this area.

[ibarrau · Accepted solution]

I guess there are sure. You might find it on google because this is a PowerBi forum and you just need to build a script or ETL to extract and store data with other tool or language code.

You might need two tutorials, one for extraction and another for storing but there should be yes.

Regards

[ibarrau · Accepted solution]

Hi. I would say no you can get older data. If you plan to analyze historic data you can store the data in a DB or DataLake to build your own history. You can build an ETL to take the data and store it somewhere at Azure.

I hope that helps,