Forum Discussion
Data Source Authentication error in Power BI Server
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 Yu
I'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).
May you please tell how to do it ?
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
yashbhutoria: we are using forms authentication, hence impersonation is required. We are always using chrome, still issue persists, we would like to use impersonate user feature. Any idea?
