Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We have an old SQL 2008 standard server which we have performed some Power BI reports against. We are upgrading to a SQL Server 2012, and would like to start using row/role-based security with Power BI. Which version of SQL Server do we need? Standard, Business Intelligence, or Enterprise?
Sincerely,
Jon Shaver
Solved! Go to Solution.
@Jnthnshvr Here is the breakdown in features by edition. You need Business Intelligence or Enterprise to run Tabular, and RLS is included in both editions.
Are you using row/role security in SQL or in Power BI?
From our understanding, we would setup the role-based security for the Power BI reports and Dashboards in the tabular database model in SSAS. So I would say in SQL?
Sincerely,
Jon Shaver
If you really want close integration with Power BI though, I would recommend SQL Server 2016.
I agree with smoupre, if you aren't pressed for time I'd wait for the release of SQL 2016. Or make a place for 2016 to support your BI efforst. It offers so much more in the way of the BI story, capabilities, and performance in tabular models.
@Jnthnshvr Here is the breakdown in features by edition. You need Business Intelligence or Enterprise to run Tabular, and RLS is included in both editions.
Saw that comparison site, but was not certain if I was reading it right. Thanks for the assistance!
I will pass the info about 2016 along, but I do not know if the people holding the purse strings will wait that long. 🙂
Sincerely,
Jon Shaver
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |