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...
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

     

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