Filter Rows based on Logged in user. (Odata and Power Query - Project Server /Office 365) RRS feed

  • Question

  • Hi

    I am querying data from the Project Online Odata feed and using Power Query to get and transform it.

    I want to filter the rows based on the logged in user.

    Could anyone advise if there is a way to do that?



    Monday, February 27, 2017 5:22 PM


  • There is currently no function in Power Query that returns the Username.

    What you can do is

    1) retrieve that name using VBA or DAX

    2) Pass this as a parameter to a cell in an Excel-sheet

    3) Pass this cells value to Power Query as a parameter

    & Yes, the user will be able to edit this, so this is no security at all, just a convenience-function.

    Imke Feldmann TheBIccountant.com

    Monday, February 27, 2017 6:14 PM