It was a crazy week for Power BI. There were quite a lot of announcements, so I’ll try to wrap them up in one single blog post and share my thoughts as well.
POWER BI DESKTOP
Again an amazing release (May 2017). Noticeable features are:
There are plenty more of nice features, so check them out in the release announcement.
POWER BI ON PREMISES vs POWER BI PREMIUM
The biggest announcement however was Power BI Premium. Basically it’s a new pricing tier. It will give you the following benefits:
And now the kicker:
Of course this raises some questions.
> I don’t want my data in the cloud! Why would I buy a Power BI Premium license to have everything local?
Luckily you can also install Power BI Report Server if you have a SQL Server Enterprise Edition license with software assurance. BI for the masses? BI for the paying masses that is. Keep in mind the same restriction as with Power BI Premium applies: report publishers need a pro account. That’s right, even if you have everything local, you still need Office365 licenses! What if you don’t have Office365? I’m told you can get the Power BI licenses through volume licensing. But wait, there’s more. Exporting a report (what a lot of users do), is considered as content creation. In other words, those users also need pro accounts. I can’t wait to see my clients faces when I tell them this.
> But wait! Power BI Desktop report hosted locally in Power BI Report Server need a Analysis Services database (since currently only live connections are supported). And SSRS reports need a report database. Do I still need an extra SQL Server license?
Well no fortunately. Power BI Report Server comes with a SQL Server Technology License, which means you can use SQL Server to support Power BI Report Server. This is similar to other software products that come with SQL Server, such as System Center. However, once you use that SQL Server instance for something else (for example, users connect to SSAS with Excel), you will need a proper license.
> I already have SQL Server EE+SA in an earlier edition with SSRS. Can I install Power BI Report Server?
Yes you can. Any SQL Server EE edition is supported, from 2012 to 2016 and beyond. If you already have SSRS installed, they should work side by side.
PRO vs FREE
There was some confusion between what free Power BI accounts could do and for which features you needed a pro account. Microsoft simplified things a bit: A free Power BI account can do everything a pro account can, except sharing your reports/dashboards. So you are free to do what you want, but it stays personal. To soften the blow, existing free accounts get a free trail period of a pro account.
I know some people really don’t like this, but here’s my personal opinion:
I hope this blog post clears out some of the confusion that exists about all those Power BI announcements. For more info, read the actual Power BI Premium announcement or the accompanying white paper.
I'm hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM UTC.…
The slides and scripts for my session "Tackling the Gaps & Islands Problem with T-SQL…
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added as…
In Azure Data Factory (ADF, but also Synapse Pipelines and Fabric Pipelines), you have a…
I wrote a piece of SQL that had some new T-SQL syntax in it: IS…
I'm very excited to announce I've been selected as a speaker for dataMinds Connect 2024,…