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 recognized as a valid DateTime.
At line:1 char:15
+ ... ctivities = Get-PowerBIActivityEvent -StartDateTime '2021-04-08T07:00 ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidArgument: (2021-04-08T07:00:00:000:String) [Get-PowerBIActivityEvent], FormatException
+ FullyQualifiedErrorId : StartDateTime is not a valid DateTime.,Microsoft.PowerBI.Commands.Admin.GetPowerBIActivityEvent

 

My Attempts to resolve:

1)

$activities = Get-PowerBIActivityEvent -StartDateTime '2021-04-08T07:00:00:000' -EndDateTime '2021-04-08T10:59:59:999' | ConvertFrom-Json | Out-File -FilePath C:\MyAuditLog

 

2) $activities = Get-PowerBIActivityEvent -StartDateTime '2021-04-08T07:00:00+0000' -EndDateTime '2021-04-08T10:59:59+0000' | ConvertFrom-Json | Out-File -FilePath E:\AuditLogs

 

Both attempts produce write errors and and the same 'Bad request'

 

Please can anyone help?

 

 

2 Replies

  • 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