pbiscripts/Report-Rebind-AllReportsFromWorkspaceToDataset.ps1 at main · RuiRomano/pbiscripts · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
#Requires -Modules @{ ModuleName="MicrosoftPowerBIMgmt"; ModuleVersion="1.2.1026" }

param(
    $workspaces = @(
        # Demo Pipelines - Sales Reports
        @{
            workspaceId = 'aafc842b-f6d8-4006-bbdc-0eb2130b3fa6'
            ; datasetId = 'e0f9d017-7e56-45ec-b39c-d09352a64828'
        }
        ,
        @{
            workspaceId = 'e1a86102-084c-4cb3-b4d8-addf75d38e6c'
            ; datasetId = 'efd01a85-b741-4205-b0d3-afe8beea9ce8'
        }
        ,
        @{
            workspaceId = '35314361-6641-4c5b-a6e6-91bb10c60ed0'
            ; datasetId = 'a94e51e4-e49a-4878-b223-ae3d8bd4b205'
        }
        ,
        # Demo Pipelines - Marketing Reports
        @{
            workspaceId = '54dd21eb-a543-461b-b947-03ff40db93fd'
            ; datasetId = 'e0f9d017-7e56-45ec-b39c-d09352a64828'
        }
        ,
        @{
            workspaceId = 'da58456c-45c7-418a-8e89-bbbb3c1618ac'
            ; datasetId = 'efd01a85-b741-4205-b0d3-afe8beea9ce8'
        }
        ,
        @{
            workspaceId = 'e6386d06-8368-49da-a796-e47fb8b23fd4'
            ; datasetId = 'a94e51e4-e49a-4878-b223-ae3d8bd4b205'
        }
    )
)


$ErrorActionPreference = "Stop"
$VerbosePreference = "Continue"

$currentPath = (Split-Path $MyInvocation.MyCommand.Definition -Parent)

Connect-PowerBIServiceAccount

foreach($workspace in $workspaces)
{
    $workspaceId = $workspace.workspaceId
    $datasetId = $workspace.datasetId

    $reports = Get-PowerBIReport -WorkspaceId $workspaceId

    foreach ($report in $reports)
    {

        $reportId = $report.Id

        Write-Host "Rebinding report '$workspaceId/$reportId' to dataset '$datasetId'"

        $bodyStr = @{datasetId = $datasetId} | ConvertTo-Json

        Invoke-PowerBIRestMethod -url "groups/$workspaceId/reports/$reportId/Rebind" -method Post -body $bodyStr -ErrorAction Continue

    }
}