Effective user name on SSAS direct query datasources in PBIRS

[pdeville]

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.

[v-qiuyu-msft]

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

[pdeville]

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.

[pdeville · Accepted solution]

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.

[inayatkhan]

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

[pdeville]

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

[inayatkhan]

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?

[pdeville]

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.