Forum Discussion

BI_Developer's avatar
BI_Developer
Frequent Visitor
9 years ago

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 abo...
Need Help
parry2k's avatar
parry2k
Super User
9 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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.

  • BI_Developer's avatar
    BI_Developer
    Frequent Visitor
    9 years ago

    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's avatar
    BI_Developer
    Frequent Visitor
    9 years ago

    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's avatar
      v-sihou-msft
      Microsoft Employee
      9 years ago

      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,