Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Premium performance with multiple users on different reports

Hi all,    My organization is debating whether to switch to Power BI Premium to share our dashboards to our clients. Let's say we created 25ish reports (each with its own MS SQL database imported;...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

As suggested by Anonymous ,those factors you should consider before choosing a premium capacity, what's more, premium capacity is a better choice for collaboration,as you said, you hope the ones you shared with have the authority to view and interact with visuals which requires them have the Pro license or your contents are in Premium capacity,so the best choice for your company is to switch to Power BI Premium.

 

Best Regards,
Kelly

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you all for the helpful answers. 

If we decide to go for Premium I know that it will currently be hosted in Ireland. In case of a Brexit however, it will drop out of the EU which is unfortunately not an option for us. 

So, I was wondering whether it was also possible to do the hosting ourselves? And what costs would be associated with this? Is Power BI Report Server this particular option?

 

Kind regards,

  • nickyvv's avatar
    nickyvv
    Icon for Most Valuable Professional rankMost Valuable Professional
    6 years ago

    Anonymous to react on Brexit: Ireland is not part of Brexit, but Northern Ireland is, so that won't be a problem.

    There is also the West Europe region which is located in The Netherlands, is that an option for you?

     

    Hosting Premium

    I am not aware of the option of hosting Premium yourself. Power BI Report Server is the SSRS-version accompanied with Power BI Premium, so that's not the same as Premium itself. In addition to a regular SSRS-server it can host Power BI reports (.PBIX), Excel files, and paginated reports (.RDL). Have a look at What is Power BI Report Server? if you want to have more information.

     

    25 datasets in Premium

    To add to the other answers above: if you have to load the 25 datasets into memory all at once, they can't exceed the capacity limit of the Power BI Premium SKU you choose. So for example if you choose a P1 (which has 25GB), the average memory of you model can only be 1GB in memory. Which is 3-4 times as big as the pbix file itself as GilbertQ mentioned.

     

    Did this help you or did I answer your question?
    Then please give kudos or mark my post as a solution!
    My blog: nickyvv.com
    Twitter: @NickyvV

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      My mistake on the Ireland part, I mistook it with Northern Ireland. So, hosting in Ireland would not be problem. We are located in The Netherlands so that would be the best option. However, I tested publishing some reports and it stated that my data was stored in North Europe (Ireland). 

       

      Reading the comments, it seems like I would need to have a server with bigger memory. Like a P3 node or multiple P1 nodes? My current PBIX files would be 2GB in size, so 8GB in memory. This means only 3-4 reports can be loaded into memory at the same time, which is not desirable. 

       

      Kind regards

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        6 years ago
        Hi there

        What you could do is when running Power BI Premium you could use the Geolocation feature and host the Power BI Premium in the Netherlands.

        The reason you have it stating it is in Ireland is because your default tenant is there, which was created before there was an option in Netherlands.