topic Re: Power BI Report Server interaction with SSAS Multidimensional Cube with row-level security in Report Server

Power BI Report Server interaction with SSAS Multidimensional Cube with row-level security

sunilravinder — Wed, 13 Sep 2017 16:58:17 GMT

Hi,

We have SSAS multidimensional cube configured with dimension security. We have a Power BI Report Server configured with the live data source connecting to the cube. We are using Windows authentication with "Log in using these credentials, but then try to impersonate the user viewing the report " checked. When we test the connection we are getting the following error:

"XML for Analysis parser: The 'Domain\Username' value of the 'EffectiveUserName' XML for Analysis property is not valid."

The goal is logged in user credentials pass to the SSAS Cube for it to respond effectively with dimension security. Does anyone know where any configuration changes need to be made. To note the 'Domain\Username' is an administrator of the analysis services database.

Thanks,

Sunil

Re: Power BI Report Server interaction with SSAS Multidimensional Cube with row-level security

sunilravinder — Tue, 12 Sep 2017 22:10:33 GMT

Hi,

We have SSAS multidimensional cube configured with row-level security. We have a Power BI Report Server configured with the live data source connecting to the cube. We are using Windows authentication with "Log in using these credentials, but then try to impersonate the user viewing the report " checked. When we test the connection we are getting the following error:

"XML for Analysis parser: The 'Domain\Username' value of the 'EffectiveUserName' XML for Analysis property is not valid."

The goal is logged in user credentials pass to the SSAS Cube for it to respond effectively with row-level security. Does anyone know where any configuration changes need to be made. To note the 'Domain\Username' is an administrator of the analysis services database.

Thanks,

Sunil

Re: Power BI Report Server interaction with SSAS Multidimensional Cube with row-level security

sunilravinder — Tue, 12 Sep 2017 22:14:14 GMT

Hi,

"XML for Analysis parser: The 'Domain\Username' value of the 'EffectiveUserName' XML for Analysis property is not valid."

Thanks,

Sunil

Re: Power BI Report Server interaction with SSAS Multidimensional Cube with row-level security

Jon-Heide — Thu, 14 Sep 2017 00:13:45 GMT

Hi Sunil - what you describe seems correct and that it should correctly impersonate the user. One thing to try, ensure you are using the latest build of the June PBI Report Server release. There was a bug, fixed in the update, where using impersonation did not function correctly. Also, you can check your config, by using a PBI report that contains a measure = username. When you view report, you can see in the report what user it is running under. Also make sure hte SSAS server is joined to same domain, so it can resolve the user identity.

Re: Power BI Report Server interaction with SSAS Multidimensional Cube with row-level security

sunilravinder — Thu, 21 Sep 2017 23:41:08 GMT

Hi,

We realized we are doing data-level security which is not supported by Power BI. Once we removed it and made it row-level security it worked.

Thanks,

Sunil