Issues connecting Report Server (on DMZ) to SSAS cube (on local LAN)

Anonymous — Mon, 03 Dec 2018 00:20:43 GMT

Hi all,

I have a client that hs the following requirements:

- Enable external users to connect to their DMZ and show them Power BI reports

- Implement Row Level Security for those users

- Load the data from an internal SSAS cube

I'm trying to configure the following architecture in order to achieve this, but I'm having two problems I can't solve and I'm starting to think this architecture is not actually possible.

The issues I have are:

Can't manage to allow Report Server (DMZ) to connect to the cube (internal LAN).
Can't manage to configure Row Level Security on Power BI

1- When I create the report on Power BI and connect to SSAS, I don't have any option regarding the authentication method, so I assume it uses windows authentication, which works inside the LAN, but when I save the report to the Report Server on the DMZ (outside the domain) it doesn't work anymore.

Is it possible to connect to SSAS using a non domain user? I don't see any option.

2- When I talked to Microsoft support they told me that in this architecture I would need to implement Row Level Security on the Power BI side, but when I edit the report on Power BI (connected to SSAS), the "manage roles" option is greyed out and I cant configure any security.

Thanks for any help you can provide!

If this architecture is not possible, I would like to know which would be the recommended solution in order to meet my client's requirements.

Thanks!

Juan Manuel

Re: Issues connecting Report Server (on DMZ) to SSAS cube (on local LAN)

Anonymous — Wed, 12 Dec 2018 00:25:52 GMT

I know I'm late to the party.

The only workaround I can think of is to upgrade your SSAS to 2017 which has the option to add external users as well.

I'm intrested to know how did you re-architectured the solution to your client.

Cheers,

Hari T

topic Re: Issues connecting Report Server (on DMZ) to SSAS cube (on local LAN) in Report Server

Issues connecting Report Server (on DMZ) to SSAS cube (on local LAN)

Re: Issues connecting Report Server (on DMZ) to SSAS cube (on local LAN)