Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I am trying to export a Power BI report to a PDF file using a powershell script. The report exports fine when I leave out the powerBIReportConfiguration portion, but I get blank pages when I try to use an RLS role. This makes me feel like I am doing it wrong. Any help is appreciated.
$body = '{"format":"PDF",
"powerBIReportConfiguration" : {"identities": [{ "username": "'+$user+ '",
"roles": [ "'+$role+'" ],
"datasets": [ "'+$datasetID+'" ]
}]
}
}'
$url = "https://api.powerbi.com/v1.0/myorg/groups/"+$workspaceID+"/reports/"+$reportID+"/ExportTo"
$export = Invoke-PowerBIRestMethod -Method POST -Url $url -Body $body -ContentType application/json | ConvertFrom-Json
$exportID = $export.id
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |