Reply
Frequent Visitor
Posts: 7
Registered: ‎01-04-2018
Accepted Solution

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?

 

 

 

 


Accepted Solutions
Highlighted
Moderator
Posts: 9,540
Registered: ‎03-10-2016

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.

View solution in original post


All Replies
Highlighted
Moderator
Posts: 9,540
Registered: ‎03-10-2016

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.