Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
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
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
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.
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
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries