Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 4 | |
| 3 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 3 |