Trying to use the export paginated reports API and I know unchecking "Report viewers can only access this data source with their own Power BI identities" (or mapping to a gateway) allows the report to export as expected, but I want to keep the SQL authentication for additional security, I thought I could use the identities blob section to pass the authentication token, so I threw together an authentication app to get a token, and pass that along but still isn't working. What am I missing? Is the token not for my username but some other system account? Thanks!
Authentication API:
"uri": "https://login.microsoftonline.com/a8f00bfd-/oauth2/v2.0/token",
"method": "POST",
"headers": {
"Content-Type": "application/x-www-form-urlencoded"
},
body content:
Token Returned From Above API
"token_type": "Bearer",
"expires_in": 3599,
"ext_expires_in": 3599,
"access_token": "eyJ0eXAiOiJKV1Q"
Export Paginated Reports API Call:
{
"host": {
"connectionReferenceName": "shared_powerbi",
"operationId": "InitiateExportToFileForPaginatedReports"
},
"parameters": {
"groupid": "44c5e8bf",
"reportid": "d02a3e08",
"ExportPayloadPaginatedReport/format": "PDF",
"ExportPayloadPaginatedReport/paginatedReportConfiguration/identities": [
{
"username": "sduval@elements.org",
"identityBlob/value": "eyJ0eXAiOiJKV1Qi"
}
]
}
}
------------------------------
Sam Duval
Data Quality Analyst
Element Financial
Indianapolis IN
------------------------------