RLS stands for Row Level Security and is a function within Power BI used to securely manage what the users see. I am reusing the steps from the Power BI embedding blog, and continuing with the same dataset to define RLS. Another big thanks to Jeroen Vos for teaching me PowerBI.
We start the process in Power BI for Desktop. Open the same report, and then navigate to Modeling and Manage Roles.
This brings up a DAX console, and I will chose the “Address 1: Country/Region”
Now we can test the DAX by simulating how it is with another user login. This function is something I wish we had in Dynamics!!!
Notice that the data has changed!:) NB! Remember to publish changes to PowerBI.com
The API approach has been available for a long time, but now the autonumber is available through the config. Jonas Rapp’s autonumber solution in XrmToolbox has been absolutely one of the best tools for this purpose so far, and not we might not need it any more. I belive the first release is missing some of advanced options that Jonas has, but it might work for most of us.
NB! you can only change the field to autonumber via powerapps.com. The Dynamics classic doesn’t support this. Below is the name field from a new entity. For the first time in EVER I could change the field type!!:)
I know we are supposed to use the UI, but it’s not ready for all purposes yet. Therefore it is nice to know that you can force the classic view for a little while longer. If for some reason you can’t use this approach, you can also change the URL like Jamie Bowman mentions here