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. 


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

    Saturday, February 24, 2018 9:09 AM


  • Are you talking about Power BI? You can use row level security. Adam is the expert.

    Self Service BI Expert using Power Pivot

    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