I have recently set up a Power BI server on-prem and am looking to secure a report. This report has data for all departments and I am wanting to have only the user for each department see their own data.
For example -
In the report, there is data for HR and Finance and there is a dropdown for each. I would like to give permission to the HR user but only to see their data and not that of Finance.
Can anyone tell me the best way to do this?
You can see Riccardo Muti's comment:https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31122463-dynamic-row-level-securi...}
From this article, RLS in Power BI report server will be available in January 2019 update.