Forum Discussion
RLS - Security menu not appearing anymore
Community ChampionHmm, 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.
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.
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
- Greg_Deckler
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 :)
