Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Get-PowerBIActivityEvents returns empty nodes

Powershell script previously working to retrieve activitiy logs using Get-PowerBIActivityEvents cmdlet now returns a large but empty json

 

This is the call I am doing*

 

    $Date = Get-Date

    if (!(Test-Path $FileName -PathType Leaf)) {
        $StartDate = $Date.ToString("yyyy-MM-dd")+"T00:00:00.000Z"
        $EndDate = $Date.ToString("yyyy-MM-dd")+"T23:59:59.999Z"
        $Activity = Get-PowerBIActivityEvents -StartDateTime $StartDate -EndDateTime $EndDate
        $Activity | Out-File -FilePath $FileName
 
When doing an in-line Write-Host on $Activity it shows the same as the saved file. This script was working yesterday and last week when I first created this, has there been an update to the api? Can anyone see the bug here?
 
* I am calling this under a foreach($i in (x..y) ) {} to iterate over a range of dates but its returning the same empty valueless json on all dates, 1 with ~100 nodes, 1 date returns only 2 nodes
General Comment
  • Anonymous's avatar
    Anonymous
    2 years ago

    After much trouble shooting the issue seemed to be with using vscode, when I switched to powershell ISE it worked fine. I'm assuming vscode and powershell ISE had some differences in versions of PS or the modules

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    After much trouble shooting the issue seemed to be with using vscode, when I switched to powershell ISE it worked fine. I'm assuming vscode and powershell ISE had some differences in versions of PS or the modules

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    According to your description, it seems that it only return empty json when call REST API to get activitiy logs. Howevery, before it is working normally. Am I right? To troubleshoot this issue, please follow the steps below:

    1. Check the PowerShell module version: Ensure that you are using the latest version of the Power BI PowerShell module.

    Update-Module -Name MicrosoftPowerBIMgmt

    2. Verify the authentication: Make sure that you are authenticated correctly to access the Power BI service. 

    Power BI Cmdlets reference | Microsoft Learn

    Connect-PowerBIServiceAccount   # or use aliases: Login-PowerBIServiceAccount, Login-PowerBI

    3. Check the date range: Verify that the date range you are specifying is correct and includes the desired activity logs. Double-check the start and end dates in your script.      

    4. Test with a single date: To isolate the issue, try running the script with a single date instead of iterating over a range of dates. This will help determine if the issue is specific to the date range or if it persists even with a single date.

    Get-PowerBIActivityEvent (MicrosoftPowerBIMgmt.Admin) | Microsoft Learn 

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

    Best Regards