Power BI Premium Business Case

[mcornfield]

Hello,

I have been tasked to look into the Advantages of upgrading to PowerBI Premium.

Right now we have 188 Pro Licences currently assigned. We probably will have 300 "builders" but there will be over 2000 people in the company that would be consuming

1. Can people in the company without Pro Licences see Reports the people with Pro licences Created?

2. We plan on using Snowflake to house our Data and using a DirectQuery to pull into PBI. Would this make Premium not really worth it? I get confused with the talk about the Size of reports and Storage.

3. Can someone View a Report on their Mobile device using PBI App without a Pro Licence?

4. What other Advantages are there?

[Anonymous]

An option if only used in-house is the Power BI Report Server. It is SSRS on steroids. If you have an SQL Server Enterprise core license, on a Microsoft EA, you can install this on the SQL Ent server for free. You will only need a Pro license to publish (Not needed, but a Microsoft Requirement). This way, no-one needs a Power BI Pro licence, and every user in your organisation with an Active Directory account can view the reports with security applied like windows folders on network drives. No license is needed for any of the Report developers, only the users that will publish. Please note, you will need to use the PBIRS desktop version of the app when creating your reports and not the one you are currently using.

I hope this helps and helps anyone else in the same situation as this is not known by many.

[v-stephen-msft · Accepted solution]

Hi @mcornfield 

1. Yes, if the report is in the Premium capacity, free users can view the report.

2. There's a one-million-row limit for cloud sources, with on-premises sources limited to a defined payload of about 4 MB per row (depending on proprietary compression algorithm) or 16MB data size for the entire visual. Certain limits may be raised when using Premium capacity. The limit doesn't affect aggregations or calculations used to create the dataset returned using DirectQuery. It only affects the rows returned. Premium capacities can set maximum row limits, as described in this post.

3. Only Power BI Pro users can publish or share content with other users or consume content that's created by others, unless a Power BI Premium capacity hosts that content. 

4. Mainly, the advantage garnered through using Power BI Premium is the dedicated capacity and the ease of access for those that need to consume the data / reports. 

For example, with Power BI Premium, you and your organization's users get the following capabilities:

• Greater scale and performance for your Power BI reports
• Flexibility to license by capacity
• Best-in-class features for data visualization and insight-extraction such as AI-driven analysis, composable and reusable dataflows, and paginated reports
• Unify self-service and enterprise BI with a variety of Premium-only capabilities that support heavier workloads and require enterprise scale
• Built-in license to extend on-premises BI with Power BI Report Server
• Support for data residency by region (Multi-Geo) and customer-managed encryption keys for data at rest (BYOK)
• Ability to share Power BI content with anyone (even outside your organization) without purchasing a per-user license

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aj1973]

Hi @mcornfield 

Answers in bleu

1. Can people in the company without Pro Licences see Reports the people with Pro licences Created? Yes if you don't use RLS in your reports or you Publish to Web(Public) the Embed code.
2. We plan on using Snowflake to house our Data and using a DirectQuery to pull into PBI. Would this make Premium not really worth it? I get confused with the talk about the Size of reports and Storage. The connection mode to the data source has nothing to do with Premium or not. Premium is more for usage capacity(500+ users) and big data support. in a Pro License, one Workspace can hold up to 10GB of datasets.  
3. Can someone View a Report on their Mobile device using PBI App without a Pro Licence? No. But they can open the link in any browser if this late was  Published to Web(Public)
4. What other Advantages are there?