How to import office 365 usage analytics data to SQL DB using Azure data factory?

Spurthi Prakash 1

Hello Team,

I would like to import office 365 usage analytics dataset from below screenshot to our DB.
Because it only keeps the Useractivity and Userstate table data for sometime and we want to keep historic data.

MartinJaffer-MSFT 26,026 Reputation points

2022-06-27T18:02:49.48+00:00

Hello @Spurthi Prakash and welcome to Microsoft Q&A.

As I understand you want to pull some data from office 365, and are trying to use the OData connector to do so.

The error message you shared, Supported content type could not be found... and A supported MIME type could not be found that matches the content type of the response... point to the stage in which the server (O365) negotiates with the client (Copy activity) what format the data should be returned in.

The copy activity wants some form of JSON, but O365 doesn't seem to support that?
Office 365 is actually beyond the area I work with, so I am not sure what form the data usually exports in. Have you exported this type of data before? Do you know what form it usually comes in? XML?
Spurthi Prakash 1 Reputation point

2022-06-28T04:41:11.433+00:00

Thanks for your reply, but we are customizing the O365 usage analytics report in Power BI, we connected the data through Odata feed-reports.office.com/pbi/v1.0/… and it is successfully connected. Now here we have two table UserActivity and UserState which has one month data where it gets refreshed every month and so we wanted to save the historic data for analysis. So, we are trying to store the month on month data in Azure SQL DB with the help of copy activity in Azure Data Factory. Please could you help how do we go forward?
Deepak Rawat 1 Reputation point

2022-11-28T19:50:01.123+00:00

@Spurthi Prakash were you able to find any alternative solutions to this. We are also trying to import usage analytics data to SQL.