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 ?
Connect to your SSAS server, right click on the server, chose properties, chose security and add the account there. You need to be an SSAS admin or server admin to be able to do so.