CODEWITHSUNDEEP
powershellpowerbi
EricShahi
EricShahi

Reputation: 13

Powershell PowerBIActivityEvent Date Invalid

#LoginToPowerBI Login-PowerBI

#OutPutFile $OutPutFilePath = "c:\temp\PowerBIAuditLog.txt"

$day= get-date "2023-02-27"

Write-Output $day

$s = 1

$periodStart=$day.AddDays(-$s) $base=$periodStart.ToString("yyyy-MM-dd")

Write-Output $base

$GetActivity = Get-PowerBIActivityEvent -StartDateTime ($base+'T00:00:00.000') -EndDateTime ($base+'T23:59:59.999') -ActivityType 'ViewReport' -ResultType JsonString | ConvertFrom-Json

write-host $GetActivity

I get below error

Get-PowerBIActivityEvent : Operation returned an invalid status code 'BadRequest' At line:20 char:16

#LoginToPowerBI Login-PowerBI

#OutPutFile $OutPutFilePath = "c:\temp\PowerBIAuditLog.txt"

$day= get-date "2023-02-27"

Write-Output $day

$s = 1

$periodStart=$day.AddDays(-$s) $base=$periodStart.ToString("yyyy-MM-dd")

Write-Output $base

$GetActivity = Get-PowerBIActivityEvent -StartDateTime ($base+'T00:00:00.000') -EndDateTime ($base+'T23:59:59.999') -ActivityType 'ViewReport' -ResultType JsonString | ConvertFrom-Json

write-host $GetActivity

I get below error , If I just have Get-date it works but setting a specific date wont work ?

Get-PowerBIActivityEvent : Operation returned an invalid status code 'BadRequest' At line:20 char:16

Upvotes: 0

Views: 442

Answers (1)

Andrey Nikolov
Andrey Nikolov

Reputation: 13460

The activity data in Power BI's activity log is kept for 30 days only. You can't query it for dates older than that.

See Track user activities in Power BI.

Upvotes: 0

Related Questions