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
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: 21611 Visits: 2505
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-Forever
SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)

Group: General Forum Members
Points: 42964 Visits: 16085
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
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15424 Visits: 4951
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
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14047 Visits: 4688
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