none
Filter records based on user RRS feed

  • Question

  • Hi All, 

    I want to know if there is a possibility of filter records to be displayed based on user. I want to show records based on department. 

    Faizan.


    Regards, Syed Faizan ur Rehman, CBPM®,PRINCE2®, MCTS

    Saturday, February 24, 2018 9:09 AM

Answers

  • Are you talking about Power BI? You can use row level security. Adam is the expert. https://guyinacube.com/2016/07/row-level-security-in-power-bi-revisited/

    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au


    Edit: I just saw this was posted under Power Query. To use PQ, you would need to have each user refresh the file and pass a parameter across. This would not be a secure approach.
    Sunday, February 25, 2018 8:43 AM