Forum Discussion

yashbhutoria's avatar
yashbhutoria
Frequent Visitor
8 years ago

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...
Report Server
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

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