Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
BI_Developer
Frequent Visitor

Deployment with Live Connection to SSAS

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? 

6 REPLIES 6
v-sihou-msft
Microsoft Employee
Microsoft Employee

@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
Super User
Super User

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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

@BI_Developer

 

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

 

12.PNG

 

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

 

Regards,

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
Not applicable

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.