Deployment with Live Connection to SSAS

[BI_Developer]

Hi, we are planning to do an enterprise wide roll out of PowerBI. 

We desire that all the users have access to the data via live connection on SSAS. 

At this point I am a little bit confused about the deployment of these setting. 

What would be the steps to follow:

I develop the app in the pbi desktop with a live connection and than publish it? 

But how I can ensure that every users consumes via live connection ? 

Do I need to setup a gateway for that? 

[v-sihou-msft]

@BI_Developer

If you are creating report within power bi desktop and publish it onto power bi service, you just need to install the On-Premise Gateway the server which hosts your SSAS server. The connection will consume Gateway to make power bi service find on-premise data source.

Regards,

[parry2k]

For your on-prem SSAS using Live Connection, you need to deploy On-Prem Gateway. Since it is live connection, any user who will these dashboards/reports, data will come from your on-prem SSAS.

To make it work, yes, you need On-Prem Gateway. 

https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem-indepth/

Just to let you know we have the same setup and it works great.

Good luck and feel free to reach out if need more help.

Cheers,

P

[BI_Developer]

Thanks for the reply. 

Glad to hear that it works for you. 

Could you tell me how security is handled in this setting?

Regards

Fatih

[v-sihou-msft]

@BI_Developer

You need to provide credential when creating data source in Gateway.

To limit data access for end users, you can configure Row Level Security.

Regards,

[BI_Developer]

Thanks for the reply. 

Glad to hear that it works for you. 

Could you tell me how security is handled in this setting?

Regards

Fatih

[Anonymous]

just one small hickup on this though.

to my knoweledge the live connection to the SSAS is not supported by the Power BI embedded yet so if this is what you are planning you may want to wait.

ty,

C.K.