Forum Discussion
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?
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 :)
- Greg_Deckler10 years agoCommunity Champion
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)