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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Hybrid Power BI design

Hi everyone,

We have a client who has Power BI requirements as follows:

 

  1. They have Office 365 subscription and On-Premises environments.

  2. All users are the Office 365.

  3. They want to leverage Power BI for their SQL Server 2016 with Analytic services.

  4. Only Finance team should be able to view reports on the On-Premises environment.
    Q: Can we use Row Level Security for this?

  5. All other users can access the Power BI reports on the Office 365.

    I have seen building hybrid business intelligence environments whitepaper and the client has not used IaaS and PaaS services at the moment.

    SaaS and On-Premises.png

    Q: Can we propose what they have SaaS (Office 365) and On-Premises as they might not consider their data on Azure?


    Q: What will be the best architecture to achieve this for this client?

Thanks a ton, advance.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I would prefer following solution:

  • Assign Pro Licence or depending on the user count, to all power Bi users 
  • Install one or more gateways to connect the on premise ssas instance to the cloud 
  • Give only the finance group permission to get data from the ssas instance

 

Take a look to the on premise gateway,  I think this is what you need.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

I would prefer following solution:

  • Assign Pro Licence or depending on the user count, to all power Bi users 
  • Install one or more gateways to connect the on premise ssas instance to the cloud 
  • Give only the finance group permission to get data from the ssas instance

 

Take a look to the on premise gateway,  I think this is what you need.

Anonymous
Not applicable

Thanks @Anonymous for your suggestion. 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.