Forum Discussion

mmace1's avatar
mmace1
Icon for Impactful Individual rankImpactful Individual
4 years ago
Solved

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...

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

    • mmace1's avatar
      mmace1
      Icon for Impactful Individual rankImpactful Individual

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

    • dburke44's avatar
      dburke44
      New Member

      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-powerbiactivityevent?view=powerbi-ps, 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's avatar
    mmace1
    Icon for Impactful Individual rankImpactful 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...

     

  • 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.