Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
 View Only

Export Power BI embedded analytics paginated reports API

  • 1.  Export Power BI embedded analytics paginated reports API

    Top Contributor
    Posted 16 days ago
    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:
    client_id=8b7659be-&client_secret=nF.8Q~&grant_type=client_credentials&scope=https://database.windows.net/.default
    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
    ------------------------------