none
Power Query filters based on UserID RRS feed

  • Question

  • I have a sales dashboard built with Power Query, Power Pivot, Power View and Power Maps that I need to filter based on the user that opens the dashboard. Users in ABCD territory, should see sales data for ABCD sales, but should not see sales from ZYXW territory.

    We do this all the time in SSRS using User!UserID as a parameter passed into a stored procedure, but I am not familiar with what function within Power Query would pass the user ID as a parameter into the stored procedure.

    Any help would be greatly appreciated.

    Thursday, June 19, 2014 5:47 PM

Answers

All replies

  • There's no way to do this in Power Query today and we don't have any plans to add it. What's the back-end server here? If it's SQL Server, you can get the current user with "suser_name()" inside the stored procedure.
    Friday, June 20, 2014 3:37 AM
  • I have solved this limitation by automatically producing one file per user on the dashbord. This also reduce the amount of data per user so the response is fast.

    In the database MS SQL there are a number of "temporary" tables which are sources to the Power Pivot

    database. Those tables are loaded with subsets of data per user and the database is refresh and published

    on the dashbord (Power View). The tables are loaded by stored procedures with the users ID as parameter. Programmed with VBA. No SharePoint in this case.

    Gosta Munktell

    Thursday, September 4, 2014 9:19 AM