topic Effective user name on SSAS direct query datasources in PBIRS in Report Server

Effective user name on SSAS direct query datasources in PBIRS

pdeville — Tue, 28 Nov 2017 15:06:07 GMT

I am testing SSAS direct query data sources in PBIRS and it appear it does not use effective user name.

Is this the expected behaviour?

This coulds be an issue for my client, when the users don't use kerberos to connect to PBIRS; In this situation kerberos delegation is not possible and the user can't view dashboards connected to remote SSAS server in direct query.

Re: Effective user name on SSAS direct query datasources in PBIRS

v-qiuyu-msft — Wed, 29 Nov 2017 08:30:27 GMT

Hi pdeville,

Is there any reason you can't configure Kerberos? From this article, if the SSAS server and PBI RS in different machine, Kerberos is required: https://docs.microsoft.com/en-us/power-bi/report-server/configure-kerberos-powerbi-reports

Best Regards,
Qiuyun Yu

Re: Effective user name on SSAS direct query datasources in PBIRS

pdeville — Mon, 04 Dec 2017 17:06:02 GMT

Well, in my current project, PBIRS will be exposed through internet (no kerberos here), and my client feels instaling WAP + ADFS is to complex and not realy required.

Re: Effective user name on SSAS direct query datasources in PBIRS

pdeville — Fri, 23 Feb 2018 13:18:10 GMT

As a workaround, on SSAS data sources, we can specify a windows account for the connection and force the "log on as the connected user" to apply an effective user name on the SSAS connection and apply the role based access rights defined in SSAS cubes.

This only work for SSAS data sources. To my knowledge, there is no workaround for SQL DB and other data sources.

Re: Effective user name on SSAS direct query datasources in PBIRS

inayatkhan — Tue, 08 May 2018 11:47:54 GMT

Hi, Please could you be very specific about how the following was accomplished : "force the "log on as the connected user" to apply an effective user name on the SSAS connection".

Thanks

Inayat Khan

Re: Effective user name on SSAS direct query datasources in PBIRS

pdeville — Wed, 09 May 2018 10:39:40 GMT

Hi,

It's an option when you edit the SSAS datasource in PowerBI RS.

"Log in using theses credentials, but then try to impoersonate the user viewing the report".

Re: Effective user name on SSAS direct query datasources in PBIRS

inayatkhan — Wed, 09 May 2018 12:47:39 GMT

Thank you "pdeville". However this appears a different connection type to the the Gateway Clusters and the Analysis services connection set up on the Power BI Service.This is shown below. Could you elaborate on the connection type that you showed?

Re: Effective user name on SSAS direct query datasources in PBIRS

pdeville — Wed, 09 May 2018 16:22:00 GMT

This topic is about Power BI Report Server (or PBIRS), the on-premise version of Power BI, not the cloud version.

Theses are two differents products

Since it is a on-premise solution, PBIRS does not use the data gateway.