topic Re: Data Source Authentication error in Power BI Server in Report Server

Data Source Authentication error in Power BI Server

yashbhutoria — Sat, 30 Dec 2017 11:28:21 GMT

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.

Re: Data Source Authentication error in Power BI Server

v-qiuyu-msft — Mon, 01 Jan 2018 02:50:55 GMT

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

Re: Data Source Authentication error in Power BI Server

yashbhutoria — Tue, 02 Jan 2018 12:36:28 GMT

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.

Re: Data Source Authentication error in Power BI Server

pbx — Wed, 03 Jan 2018 04:19:26 GMT

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).

Re: Data Source Authentication error in Power BI Server

yashbhutoria — Wed, 03 Jan 2018 18:23:35 GMT

May you please tell how to do it ?

Re: Data Source Authentication error in Power BI Server

pbx — Wed, 03 Jan 2018 19:28:33 GMT

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.

Re: Data Source Authentication error in Power BI Server

yashbhutoria — Thu, 04 Jan 2018 03:17:32 GMT

Didn't work. Same error showing up.

Re: Data Source Authentication error in Power BI Server

pbx — Thu, 04 Jan 2018 03:27:30 GMT

Can you provide details of error from the log files

Re: Data Source Authentication error in Power BI Server

yashbhutoria — Thu, 04 Jan 2018 11:01:59 GMT

Where can I find those ?

Re: Data Source Authentication error in Power BI Server

pbx — Thu, 04 Jan 2018 18:01:51 GMT

On the server, where you installed the PBI Reprot Server, there's a folder called LogFiles, which contains log files for every service.

Re: Data Source Authentication error in Power BI Server

yashbhutoria — Fri, 05 Jan 2018 11:48:01 GMT

Hey! just found out that it was fault of Microsoft Edge browser. It works fine in Google Chrome. Thanks Anyways!

Re: Data Source Authentication error in Power BI Server

prazzy88 — Tue, 27 Mar 2018 11:05:43 GMT

@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?

Re: Data Source Authentication error in Power BI Server

yashbhutoria — Tue, 27 Mar 2018 11:05:50 GMT

Yes, Just don't use Edge or Internet Explorer and it will work just fine

Re: Data Source Authentication error in Power BI Server

prazzy88 — Tue, 27 Mar 2018 11:09:12 GMT

@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?

Re: Data Source Authentication error in Power BI Server

yashbhutoria — Tue, 27 Mar 2018 11:18:10 GMT

Try opening chrome as another user

Re: Data Source Authentication error in Power BI Server

Anonymous — Fri, 10 Jun 2022 10:24:14 GMT

I have the same issue even with Chrome

The user is admin and i'm using SSAS Database and PBI RS May 2022

Re: Data Source Authentication error in Power BI Server

Anonymous — Sun, 12 Jun 2022 17:09:17 GMT

Issue fixed after changing the password for the expired SSAS service startup account, and then restarting the service