Forum Discussion
PowerBI service issue with Direct query: Login failed for user '<token-identified principal>'
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)
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)