OLS Fabric Data Warehouse
I know OneSecurity is coming, hopefully this quarter, but in the meantime I'm trying to figure out some security for my data warehouse. My end goal is that I would have two groups of people, those who can see cost and those who cannot. I was hoping to just mask the cost for the one group and allow the other group to see cost. This would save me having to make separate reports and models that contained cost and ones that did not. This seems doable with OLS or CLS. I just cannot figure out how to assign an Entra Security Group to a Database Role or Grant/Deny access to the Entra Security Group. I receive an error that the Principal <group name> cannot be resolved. Has anyone attempted this and had success, or am I stuck waiting for OneSecurity?