Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

how Can we pass USERPRINCIPLE or USERNAME as a query parameter in power BI

Hi,

 

I have oracle store proceure and I successfully loaded data using store procedure in Power BI, now I want to excute my store procedure dynamically with paramter, it shoud executed by power BI logind ID (username) , can anyone guide me how to do this.

 

your support will be highly appreciate. 

 

Thanks,

Sunil

Need Help
  • ImkeF's avatar
    ImkeF
    5 years ago

    Hi Anonymous ,

    as lbendlin mentioned, you cannot retrieve these values with Power Query.

    How about considering a workaround that fetches the user from the database login instead?
    I'm using this function for it:

     

    = ()=>
let
    Source = MySQL.Database("myDBconnectionString", "myTableName", [ReturnSingleDatabase=true, Query="SELECT current_user"]),
    current_user = Source{0}[current_user],
    Custom1 = Text.BeforeDelimiter(current_user, "@")
in
    Custom1

     

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Thankfully this is not possible.  If you need that level of control, use Row Level Security and/or Direct Query mode against the Oracle table or view.

    • ImkeF's avatar
      ImkeF
      Community Champion
      5 years ago

      Hi Anonymous ,

      as lbendlin mentioned, you cannot retrieve these values with Power Query.

      How about considering a workaround that fetches the user from the database login instead?
      I'm using this function for it:

       

      = ()=>
let
    Source = MySQL.Database("myDBconnectionString", "myTableName", [ReturnSingleDatabase=true, Query="SELECT current_user"]),
    current_user = Source{0}[current_user],
    Custom1 = Text.BeforeDelimiter(current_user, "@")
in
    Custom1