topic Re: Deployment with Live Connection to SSAS in Developer

Deployment with Live Connection to SSAS

BI_Developer — Tue, 17 Jan 2017 10:14:08 GMT

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?

Re: Deployment with Live Connection to SSAS

parry2k — Tue, 17 Jan 2017 22:57:43 GMT

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,

Re: Deployment with Live Connection to SSAS

Anonymous — Wed, 18 Jan 2017 05:31:46 GMT

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.

Re: Deployment with Live Connection to SSAS

v-sihou-msft — Mon, 23 Jan 2017 15:10:44 GMT

@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,

Re: Deployment with Live Connection to SSAS

BI_Developer — Tue, 24 Jan 2017 15:56:15 GMT

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

Re: Deployment with Live Connection to SSAS

BI_Developer — Tue, 24 Jan 2017 15:59:28 GMT

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

Re: Deployment with Live Connection to SSAS

v-sihou-msft — Thu, 26 Jan 2017 07:36:58 GMT

@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,