Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Powershell API Export to File with RLS applied

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

 

0 REPLIES 0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors