Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
mmace1
Impactful Individual
Impactful Individual

Error using Get-PowerBiActivityEvent - 'BadRequest'

I am a Power BI Admin, and did run Login-PowerBiServiceAccount first

Say if I run:

Get-PowerBIActivityEvent -StartDateTime 2022-04-24T12:00:00 -EndDateTime 2022-04-25T12:00:00


I receive the error: 

 

Operation returned an invalid status code 'BadRequest',Microsoft.PowerBI.Commands.Admin.GetPowerBIActivityEvent

 
Not really sure how to troubleshoot...

 

1 ACCEPTED SOLUTION
matthewwi
New Member

I had this same issue today and then noticed this in the documentation:

The Get-PowerBIActivityEvent cmdlet takes a StartDateTime and an EndDateTime parameter with the same restrictions as the ActivityEvents REST API. In other words, the start date and end date must reference the same date value because you can only retrieve the activity data for one day at a time.

After I set my dates to start and end on the same day (2022-04-26 00:00:00-2022-04-26 23:59:59), then I quit receiving the error.

View solution in original post

5 REPLIES 5
Mikes2nd1
Helper I
Helper I

uhg THIS is true...  I guess since it could be an insanely huge JSON file... I guess I need to run it a lot... I wish it was a 3 day window.  I would feel a little better about missing info getting caught.

 

I guess i can simply "check" to see if a day was missed and reload that single day.... I know 30 days out and its gone.

mmace1
Impactful Individual
Impactful Individual

I am a Power BI Admin, and did run Login-PowerBiServiceAccount first

Say if I run:

Get-PowerBIActivityEvent -StartDateTime 2022-04-24T12:00:00 -EndDateTime 2022-04-25T12:00:00


I receive the error: 

 

Operation returned an invalid status code 'BadRequest',Microsoft.PowerBI.Commands.Admin.GetPowerBIActivityEvent

 
Not really sure how to troubleshoot...

 

matthewwi
New Member

I had this same issue today and then noticed this in the documentation:

The Get-PowerBIActivityEvent cmdlet takes a StartDateTime and an EndDateTime parameter with the same restrictions as the ActivityEvents REST API. In other words, the start date and end date must reference the same date value because you can only retrieve the activity data for one day at a time.

After I set my dates to start and end on the same day (2022-04-26 00:00:00-2022-04-26 23:59:59), then I quit receiving the error.

I am an admin and successfully connected upon running Connect-PowerBIServiceAccount

 

Right out of https://learn.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.admin/get-powerbiactivityev... I run the folllowing:

 

Get-PowerBIActivityEvent -StartDateTime 2019-08-10T14:35:20 -EndDateTime 2019-08-10T18:25:50

 

I still get "Bad Request"

Get-PowerBIActivityEvent : Operation returned an invalid status code 'BadRequest'
At line:1 char:1
+ Get-PowerBIActivityEvent -StartDateTime 2019-08-10T14:35:20 -EndDateT ...

 

I can't figure out what's wrong.

mmace1
Impactful Individual
Impactful Individual

oh...it has to be the same day, not just a 24 hour window.  I did not realize that, thanks!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.