title: Row level Security (RLS) in Azure Synapse vs Power BI
body: <p>I am building a new data warehouse system for one of my client and using Azure Synapse with Power BI. I am currently laying out the access framework for the system and exploring the Pros and Cons of applying ROW LEVEL Security at various points.</p>
  <p>My understanding is Power BI works best with import and if I apply RLS on the database, I am not sure how RLS would work in the Power BI.</p>
  <p>However if I apply RLS in Power BI, the reporting team would have to take care of it in every report. Also I do not want to give full security controls to the reporting team as the data is sensitive.</p>
  <p>Can anyone here please help and suggest what would be the right way to apply RLS?</p>