Forum Discussion

JJenkins2005's avatar
JJenkins2005
Frequent Visitor
8 years ago

Text Parameter for Stored Procedure

Hello,   I've been asked to create a Power BI report using a couple stored procedures accessing some confidential data. I've played around with the parameter feature on PBIDesktop, but never attemp...
JJenkins2005's avatar
JJenkins2005
Frequent Visitor
8 years ago

Thanks for the information. I was able to get that to work, but that appears to require the user to edit the query... Is there any way to run an SP, provide the user with a filter to select the parm they want, and once selected that is passed to the SP and the data is provided?  Users won't be able to edit the queries when we publish this to the service or PBIS.  

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI JJenkins2005,

 

Unfortunately, current query parameter and custom functions not work on power bi service.

 

Regards,

Xiaoxin Sheng