Connection to Azure SQL Database - Login Failed for User '<token-identified principal>'
We are having the same issues when accessing a report that has been working. Users are getting the following error from the Power BI Service for each of the visuals in the report:
Activity ID: 87c2eeb1-dc79-446a-b172-404d53f2a77c
Request ID: 598e9c3d-4794-80b9-cca2-490f7071ed60
Correlation ID: ba55a6f0-6123-af17-73fb-7f9ec16e63ad
Time: Mon Nov 22 2021 13:39:39 GMT-0500 (Eastern Standard Time)
Service version: 13.0.17186.43
Client version: 2111.3.08642-train
Cluster URI: https://wabi-us-central-a-primary-redirect.analysis.windows.net/
Activity ID: 87c2eeb1-dc79-446a-b172-404d53f2a77c
Request ID: 598e9c3d-4794-80b9-cca2-490f7071ed60
Time: Mon Nov 22 2021 13:39:39 GMT-0500 (Eastern Standard Time)
Service version: 13.0.17186.43
Client version: 2111.3.08642-train
Cluster URI: https://wabi-us-central-a-primary-redirect.analysis.windows.net/
If I try to edit credentials on the dataset, sometimes I get an error that the credentials are not valid. I can login toe SSMS with the same credentials and I have access to the database and can do select statements from the tables in the database.