Simply trying to use the power automate template to export a paginated report to an excel file. I am getting a 401 error upon testing. Seen similar posts from a few years ago but none of the suggestions seem to apply. I am the author of the paginated report so I dont think it is a permission issue. Using the same user name in automate. I confirmed the reportid is correct thru the url.
Hoping some one can provide some advice. New to automate so it may be something silly with the set up. Apologize if that turns out to be the case. Below is the code view of the request.
{
"host": {
"connectionReferenceName": "shared_powerbi",
"operationId": "InitiateExportToFileForPaginatedReports"
},
"parameters": {
"groupid": "myworkspace",
"reportid": "77d83186-340a-460e-b663-34f60533ad3f",
"ExportPayloadPaginatedReport/format": "XLSX",
"ExportPayloadPaginatedReport/paginatedReportConfiguration/identities": [
{
"username": "mxxxxxx@axxxx.com",
"identityBlob": {
"value": null
}
}
]
}
}
