Forum Discussion

New Member

10 years ago

Solved

SQL Server version required

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...

Anonymous
10 years ago
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.

Community Champion

10 years ago

Are you using row/role security in SQL or in Power BI?

Jnthnshvr
New Member
10 years ago
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
- Anonymous
  Not applicable
  10 years ago
  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.
  - Jnthnshvr
    New Member
    10 years ago
    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
- Greg_Deckler
  Community Champion
  10 years ago
  If you really want close integration with Power BI though, I would recommend SQL Server 2016.
  - Anonymous
    Not applicable
    10 years ago
    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.