Forum Discussion

chiamaka's avatar
chiamaka
Frequent Visitor
5 years ago
Solved

Get-PowerBIActivityEvent - Unexpected error. I have Power BI Admin

$activities = Get-PowerBIActivityEvent -StartDateTime '2021-04-08T07:00:00:000' -EndDateTime '2021-04-08T10:59:59:999' | ConvertFrom-Json   Error message: Get-PowerBIActivityEvent : String was not...
chiamaka's avatar
chiamaka
Frequent Visitor
5 years ago

Got it working now - I used below:


#Install-Module -Name MicrosoftPowerBIMgmt -Force
$StartDateToExtract = '2021-04-08T00:00:00'
$EndDateToExtract = '2021-04-08T23:59:59'


$activities = Get-PowerBIActivityEvent -StartDateTime $StartDateToExtract -EndDateTime $EndDateToExtract |ConvertFrom-JSON

#$activities.count

$activities | Select Id, RecordType, CreationTime, Operation, OrganisationId, UserType, Workload, UserId, ClientIP, userAgent, Activity,
ItemName, WorkspaceName, DatasetName, ReportName,
CapacityId, CapacityName, WorkspaceId, AppName, ObjectId, DatasetId, ReportId, IsSuccess,
ReportType, RequestId, ActivityId, AppReportId, DistributionMethod, ConsumptionMethod | Export-Csv -Path $activityLogOutput -NoTypeInformation