I have multiple file extracts of the audit logs for power BI. Some from before and some after December 2017.
The format change from December sometime.
I am working on files after December 2017 and ran into an issue. The number of columns/column names is not same between different activities. EX: If the activity is View Report then i have column - Dataset name and if activity is - ViewDashboard the there is a column - DashboardName
1. It is not consistent between the activities. How can i get this all records into one data set in Power BI.
2. Is iot possible to get the pre Decemebr 2017 and post version/format data into one data set?
Here are couple of sample records, highlited for type followed by the column location where the two line are not same.(this is just teh JSON string of the complete record)
{"Id":"a07a78c7-b273-3719-a066-5277a59","RecordType":20,"CreationTime":"2017-12-18T12:32:08","Operation":"ViewReport","OrganizationId":"2f55bf32-42d4-44b3-a8c2-930a82b2","UserType":0,"UserKey":"10037FFB99432","Workload":"PowerBI","UserId":"email.com","ClientIP":"10.0.0.00","UserAgent":"Mozilla\/5.0 (Windows NT 10.0; WOW64; Trident\/7.0; rv:11.0) like Gecko","Activity":"ViewReport","ItemName":"Backlog PRs","WorkSpaceName":"Proc.Buyer",
"DatasetName":"Backlog PRs","ReportName":"Backlog PRs","WorkspaceId":"951de7e3-0053-48e9-87e6-15a34","ObjectId":" PRs","DatasetId":"a31966e9-0f81-4b52-b81f-d9cc8","ReportId":"7a20aeec-1bf7-4663-87b0-87b5fa13"}
{"Id":"6d9e4875-97db-718b-7197-8597c5c3","RecordType":20,"CreationTime":"2017-12-19T12:58:07","Operation":"ViewDashboard","OrganizationId":"2f55bf32-42d4-44b3-a8c2-9302b2","UserType":0,"UserKey":"1003BF745A","Workload":"PowerBI","UserId":"email.com","ClientIP":"63.240.00.00","UserAgent":"Mozilla\/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit\/537.36 (KHTML","Activity":"ViewDashboard","ItemName":" Refinery","WorkSpaceName":" Refinery","DashboardName":" Refinery","WorkspaceId":"52499a2b-1259-49c6-ae7d-01","ObjectId":" Refinery","DashboardId":"3e999fe1-633d-4b86-ae55-ea97b236","Datasets":[{"DatasetId":"5fc26f86-a89b-45e2-828e-b7dec","DatasetName":"2017 and 2016 Refinery Alarms"},{"DatasetId":"26a3533e-9850-4fbf-b703-","DatasetName":"DDMM"},{"DatasetId":"1b839e4b-4cb8-4e3e-98f9-ce23b0e","DatasetName":"56NERY"}]}
