Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Amend Power Shell Script to save and replace older files with new ones everyday

Hi Experts

Totally new to powershell - how can i amend the following code to save the file from specific workspace in Power Bi to folders with the same name as the workspace, every day and delete the older files in the folder with the new files. 

 

Script to run at 1.00am everymorning

 

Workspace name 

Trading

Oil

Stocks

Comm

 

Folder name as above

 

Set-StrictMode -Version "latest"

$ErrorActionPreference="Stop"

<#

    Download all reports from the specified Power BI Workspace

    Ensure you have called login.ps1

#>




[System.Net.WebRequest]::DefaultWebProxy.Credentials=[System.Net.CredentialCache]::DefaultCredentials




$script:WorkspaceName="Soft Launch Power BI Central Workspace"

$OutputFolder=Join-Path -Path $PSScriptRoot -ChildPath "out"

$Script:Reports=$null

$script:Workspace=$null




function CreateOutputFolder{

    if (Test-Path -Path $OutputFolder)

    {

        Write-Host "The output folder $OutputFolder already exists. Not creating"

        return

    }

    New-Item -ItemType Directory -Path $OutputFolder

    Write-Host "The output folder $OutputFolder was created"

}



function DownloadAllReports{

    foreach ($report in $reports){

        Write-Host "----------------------------"

        Write-Host "Downloading report $($report.name)"

        $downloadPath = Join-Path -Path $OutputFolder -ChildPath "$($report.Name).pbix"

        if (Test-Path -Path $downloadPath){

            Remove-Item -Path $downloadPath

            Write-Host "Deleted report file $downloadPath"

        }

        Export-PowerBIReport -WorkspaceId $Workspace.Id  -Id $report.id -OutFile $downloadPath

        $downloadPath

    }

   

}



function GetListOfReports{

    $script:Workspace=Get-PowerBIWorkspace -Name $script:WorkspaceName

    Write-Host "Going to get all reports in the workspace: $script:WorkspaceName"

    $Script:Reports=Get-PowerBIReport -Workspace $script:Workspace

    Write-Host "Found $($reports.Count) reports in the workspace: $script:WorkspaceName"

   

}




CreateOutputFolder

GetListOfReports

DownloadAllReports