O365 Usage report - Store Historical Data

[Anonymous]

I have connected Power BI to Microsoft O365 Usage Report App (Which is an existing PBI App developed by Microsoft). I can get the dataset in my PBI Desktop as well. Microsoft refreshed the dataset every month. The issue is Dataset is designed to store data only for last 6 months. This means at any given day, dataset will have data for last 6 Months.

 I want data for more than 6 Months. Is there any way to store this data someplace so that when Microsoft refreshes the data, i will not lose any of it?

[Anonymous]

My Power BI is connected to o365 data using some API. The issue is we can only see one month data in that and Microsoft refreshed that data every month. I want historical 12 months data, Is there any way like we can get historical data also.

Please help @Anonymous  @Anonymous 

[Anonymous · Accepted solution]

@Anonymous,

Do you connect to O365 usage analytics PBIT file in Power BI Desktop? If so, you can store historic data following the guide in the post below.

https://community.powerbi.com/t5/Desktop/Storing-and-using-information-from-a-dynamic-data-source-using/m-p/207293#U207293

Regards,
Lydia