SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How does PowerBI compare with SSRS


How does PowerBI compare with SSRS

Author
Message
Rod
Rod
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28684 Visits: 2741
First, I realize this question is probably in the wrong forum. I'm sorry about that. I couldn't find any forum specific for PowerBI.

Now onto the question. Recently I was discussing PowerBI with my coworkers. We're using a mixture of MS Access report, Crystal, Excel and SSRS reports. Slowly moving to SSRS. SSRS has lots of benefits over what we've been using for many years, longer than I've been here. But I'm really beginning to see from Microsoft the push towards PowerBI. And having sat in a special SQL Saturday about a year ago in which one guy was using PowerBI, I was very impressed with its capabilities. So I was there chatting it up with my coworkers. However, I don't have any practical experience with PowerBI. One of my colleagues said that his brother works somewhere, where they were considering PowerBI, but eventually decided against it because of the cost. The price of anything is extremely important to where I work. So let me put this to you plainly, is PowerBI more expensive that SSRS?

Kindest Regards,Rod
Connect with me on LinkedIn.
pietlinden
pietlinden
SSC Guru
SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)

Group: General Forum Members
Points: 53387 Visits: 16991
I think the easiest way into PowerBI is to get Rob Collie & Avi Singh's book, and to start playing. The book is only about $30, but absolutely worth it.
PowerBI Desktop is free... Not sure what MS is doing with licensing right now.

To me, PowerBI is much more about data exploration than reporting (which is what SSRS is good for). You can download PowerBI and play with it at home. If you have a free version of SQL Server available, then PowerBI is great... It's one of the points Rob makes in his book - when you have PowerBI and a good backend database, you're golden.

You can download both PowerBI Desktop and SQL Server 2016 for free from the MS site.
xsevensinzx
xsevensinzx
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21711 Visits: 5890
If PowerBI cost is worrying you, then it's likely not what you're looking for. I think right now, it's about $9.99 per user where competitors like Tableau used to be around $1,000 per user, but now have monthly subs as low as $35 per user.

PowerBI Costs
PowerBI Enterprise Calculator

In my opinion, PowerBI is the way to go if you can afford the $9.99 per user per month. You have the 10GB per user and per workgroup (groups of users) that is pretty much like SSAS Tabular in the cloud without having to setup SSAS specifically. PowerBI allows you to remodel the data and comes with very nice visuals, filters and much more compared to SSRS. It also allows you to live query on on-prem or Azure-based SQL Servers in case 10GB is too small for your organization.

I would say it's cheaper to stick with SSRS if you already have it, but you would be missing out on some great visualization features with PowerBI if you do so. For $9.99 per user per month for pro and now with the Azure SSAS available for additional BI power, you really can't go wrong.

I think the only thing I miss about SSRS is the parameters you could set on queries that tied to filters. This is non-existant in PowerBI thus far. Other than that, PowerBI is been a great product and certainly one you should try out if you're looking for a good SSRS replacement.
Martin Schoombee
Martin Schoombee
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17008 Visits: 4734
As the others have said, a Power BI Pro license will cost you $10 per user/month. To compare it with SSRS pricing, you really need to look at the edition of SSRS and whether you have CALs or per core licences, how many users you have, whether SSRS is on a shared server or not, etc.

All of these factors will influence the comparison, and will be different for each environment. If the price comparison yields a positive outcome for you environment, you should then consider the differences in features/capabilities, especially the ones you have in SSRS but not in Power BI (email subscriptions with attachments; export into various formats; paging for tabular reports).



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search