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

Anonymous — Thu, 02 Mar 2023 08:07:24 GMT

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

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

Anonymous — Thu, 02 Mar 2023 10:32:13 GMT

Here is the answer if other User or member what to do this see link

https://sidequests.blog/2021/02/01/exporting-all-your-power-bi-reports-at-once/

You'll have to do the other POwer Shell work but its a good start

topic Re: Amend Power Shell Script to save and replace older files with new ones everyday in Developer

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

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