Forum Discussion
Data Source Authentication error in Power BI Server
The account I use for Data Source authentication shows following error
when checking "Log in using these credentials, but then try to impersonate the user viewing the report " option
but works fine after unchecking the option.
16 Replies
Hi yashbhutoria,
Which data sources do you get data from? For SQL Server databases, using the impersonation options sets the SETUSER function.
You can add a measure in a Power BI report: measure = username() to check which user impersonate when viewing the report and verify this user has permission to access data source. If it's Windows credentials, it should impersonate specified user. If it's database credential, it impersonates the unattended execution account or the service account.
For more infomration, see: https://docs.microsoft.com/en-us/sql/reporting-services/report-data/specify-credential-and-connection-information-for-report-data-sources
By the way, try to update the Power BI report server to the latest version.
Best Regards,
Qiuyun YuI'm using SSAS Database. Kerberos authentication didn't succeed so, I tried authentication by entering credentials. The credentials works just fine untill I check that impersonate option.
PS: I have updated to latest version already.
- I believe you need to add the account as admin on the SSAS server to be able to set EffectiveUserrName (i.em impersonate for SSAS).
v-qiuyu-msft and yashbhutoria: we have this issue as well in our company, the user was admin but still receiving the error while saving the report. Is there any working solution found out as of now?
Yes, Just don't use Edge or Internet Explorer and it will work just fine
