Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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
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.
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.
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
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".
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
4 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
6 | |
3 | |
3 |