cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

RLS - Security menu not appearing anymore

Hello all,

 

I've been evaluating Power BI with a power user license, and have connected to our Analysis Services data. I created a few datasets and reports. I went into the SECURITY menu to try to define some Row Level Security... I had some errors when trying to create roles... a few times. Now, the SECURITY menu doesn't even appear. I tried creating new dataset from SSAS, and still no SECURITY menu.

 

I've searched through all the settings, no idea what to do to get it back. Any tips? 

 

CapturePowerBI_RLS.JPG

Much thanks!

Jason

5 REPLIES 5
Highlighted
Super User IX
Super User IX

Re: RLS - Security menu not appearing anymore

Hmm, that's weird if it was there and then not there. I have seen this with data pulled from services like "Visual Studio Online" and "Google Analytics". What is the origin of the dataset? I have never seen this with a dataset created via Desktop.


---------------------------------------

Not link spamming! If I posted a link in reply it is because I did assume you know how to search the web but thought it was the fastest way to fix your issue.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Regular Visitor

Re: RLS - Security menu not appearing anymore

Thanks for response!

 

The data is from Analysis Services Cube - Dynamics AX 2012 R3, hosted in Azure. Using the Enterprise Gateway to talk to the cube. I created the dataset and report in the desktop app, published them.

 

What strikes me as strange is even if I add a new dataset and report the SECURITY menu item doesn't appear.

 

CapturePowerBI_RLS2.JPG

 

I tried using Get Data and adding a dataset from the SSAS datasource and neither does it give me the SECURITY option now.

 

Trying to evaluate this a an option for our reporting needs by the end of the week, implementing row level security is key to that decision making! Help appreciated!

 

- Jason

Highlighted
Super User IX
Super User IX

Re: RLS - Security menu not appearing anymore

OK, next question, are you using DirectQuery to talk to the SSAS cube or are you doing an import of the data into the data model?

 

I would try something simple, like create a CSV file and import it into a new PBIX file's data model. Publish it and see if Security menu appears.

 

Another question, are you US-based or abroad?


---------------------------------------

Not link spamming! If I posted a link in reply it is because I did assume you know how to search the web but thought it was the fastest way to fix your issue.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Regular Visitor

Re: RLS - Security menu not appearing anymore

I tried a CSV file, imported the dataset - but I don't see a SECURITY option in the [...] menu.

 

Just out of a meeting with Power BI reps, they claim it is best practice with Power BI / Dynamics AX 2012 to implement security at the SSAS level. I'm used to another BI product that has an interface for managing roles and data filters.

 

I'm going to have a technical deep dive with their rep in the short term, I will dig in deeper with them on this. Thanks very much for your assistance. I'm still puzzled by this, but I won't ask for more of your brain cycles on this item. I'll let pre-sales do some of the heavy-lifting 🙂

 

 

 

CapturePowerBI_RLS3.JPG

 

Highlighted
Super User IX
Super User IX

Re: RLS - Security menu not appearing anymore

Well, with SSAS, I can see them saying that. That being said, SSAS security can get REALLY complex pretty quickly. That is bizarre that you don't see the Security link, I see it on all of mine other than cloud-based datasets (that come from Service packs)


---------------------------------------

Not link spamming! If I posted a link in reply it is because I did assume you know how to search the web but thought it was the fastest way to fix your issue.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors