Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |