'Logic App failure: Effective identity on Azure SQL datasources with SSO enabled requires access token to be provided

3 days ago one of my Logic Apps started failing.

I re-created it from blank with only the step that fails and the same issue occurs.

Step: Power BI: Export To File for Paginated Reports

Error:

{
"statusCode": 400,
"headers": {
    "Pragma": "no-cache",
    "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
    "X-Frame-Options": "deny",
    "X-Content-Type-Options": "nosniff",
    "RequestId": "xxxxxxx",
    "Access-Control-Expose-Headers": "RequestId",
    "Timing-Allow-Origin": "*",
    "x-ms-apihub-cached-response": "false",
    "Cache-Control": "no-store, must-revalidate, no-cache",
    "Date": "Wed, 26 Jan 2022 13:17:19 GMT",
    "Content-Length": "170",
    "Content-Type": "application/json"
},
"body": {
    "error": {
        "code": "InvalidRequest",
        "message": "Effective identity on Azure SQL datasources with SSO enabled requires access token to be provided"
    }
}
}

I'm using an account that has full admin access, only used for automation jobs. The account can run the report manually just fine.

Googling the error comes up with no results.

Any ideas?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source