Forum Discussion

littlemojopuppy's avatar
littlemojopuppy
Community Champion
5 years ago

Power BI Premium vs. Azure Analysis Services

Hola!  Would like to ask for some advice on something from people more knowledgeable than I.   Company is currently paying for Azure Analysis Services (S1) to house a data model that theoreticall...
Need Help
AbhiSSRS's avatar
AbhiSSRS
Solution Sage
5 years ago

Its a really good cost saving move to push your Tabular model directly to Power BI instead of a S1. 

It may also offer you better performance for pbix when there is less load and P1 stats look good on monitor.

 

And yes the datasets can be shared across workspaces. Even the Power BI datasets which have different datasource are used can be connected live across workspaces to create reports.

  • littlemojopuppy's avatar
    littlemojopuppy
    Community Champion
    5 years ago

    Hi AbhiSSRS thanks...it would be a huge cost savings ($18k annually) to not have to pay for AAS when Power BI has more horsepower than AAS anyway.

     

    Thank you for replying!  ğŸ™‚

    One question I that concerns me is security.  Hopefully you or Greg_Deckler could help.  I publish a data set into a workspace with a given set of permissions (hypothetically BI admins only).  Can I use that data set on some reports that are published for the average user to see?  Or will permissions on the data source workspace prevent users who cannot access it from using that data.  Put more simply, if the data is published to workspace ABC, does a user have to have permissions on workspace ABC to use the data?

    • AbhiSSRS's avatar
      AbhiSSRS
      Solution Sage
      5 years ago

      Yes, the creator will have access to the Dataset and can create report in any workspace. This report can then be shared with any user who has the same license level as workspace ( Pro/PPU) and that user would not need access to the workspace that hosts the dataset. This applies for both external/internal users . eg .The PPU workspace needs PPU user and thus all workspaces that You share this dataset across for reports would also need to be in PPU capacity.

      • littlemojopuppy's avatar
        littlemojopuppy
        Community Champion
        5 years ago

        Hi AbhiSSRS.  Sorry for the delay in replying.

         

        You said "shared".  Trying to avoid sharing reports and the web of permissions that creates...we're managing access to reports via apps.

         

        Also there are roughly 700 users and all but a half dozen of us have free licenses (those of us that create content have Pro).  Does that complicate things?