Forum Discussion
PowerBI service issue with Direct query: Login failed for user '<token-identified principal>'
Underlying Error: PowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: QueryUserError
QueryUserError: Login failed for user '<token-identified principal>'.. The exception was raised by the IDbConnection interface.
Correlation ID: df264377-
Service version: 13.0.21054.54
Cluster URI: https://wabi-europe-north-b-redirect.analysis.windows.net/
Data source : Azure SQL server
Report is working in PowerBI desktop and on publish getting above error
I tried creating new report / refresh dataset / set credentials in dataset settings, nothing is working for me
Following worked for me :
1. Go to PowerBI Service
2. Select Dataset
3. Go to Settings
4. Click on Data source credentials
5. Choose Edit Credentials and enter credentials again
6. Untick the option "Report viewer can only access this data source with their own PowerBI identities using DirectQuery"Thanks to https://community.fabric.microsoft.com/t5/Issues/Login-failed-for-user-lt-token-identified-principal-gt/idc-p/2377666/highlight/true#M76816 (it is missing detailed steps so added it with images)
2 Replies
Following worked for me :
1. Go to PowerBI Service
2. Select Dataset
3. Go to Settings
4. Click on Data source credentials
5. Choose Edit Credentials and enter credentials again
6. Untick the option "Report viewer can only access this data source with their own PowerBI identities using DirectQuery"Thanks to https://community.fabric.microsoft.com/t5/Issues/Login-failed-for-user-lt-token-identified-principal-gt/idc-p/2377666/highlight/true#M76816 (it is missing detailed steps so added it with images)
- lbendlin
Super User
You can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues . If you have a Pro license you can consider raising a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
