cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nachiketjoshi Frequent Visitor
Frequent Visitor

O365 Usage report - Store Historical Data

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?

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Moderator v-yuezhe-msft
Moderator

Re: O365 Usage report - Store Historical Data

@nachiketjoshi,

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-us...

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Highlighted
Moderator v-yuezhe-msft
Moderator

Re: O365 Usage report - Store Historical Data

@nachiketjoshi,

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-us...

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.