cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ali_a Frequent Visitor
Frequent Visitor

I have issue with parameter

Hi,

I use function in sql plus and the function have be return value as parameter for due date the parameter has be enter by employee and employee don't have access for toolbar only has webpage from power bi report server. Please, I need help to give the employee enter that Value.

If there a way in what if or anything it can help me.

Thanks
4 REPLIES 4
Nathaniel_C Super Contributor
Super Contributor

Re: I have issue with parameter

Hi @ali_a ,

 Here is a link to parameters instruction and a picture of where to find them in Power Query.


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

Parametersw

 

 

parameter.PNG

 

ali_a Frequent Visitor
Frequent Visitor

Re: I have issue with parameter

Hi @Nathaniel_C

Thank you for replying.

I have been use the parameter as you mentioned but the employee user doesn't have access to edit from toolbar every time 😞
I was looking at the internet for any solution how to pass a parameter in the same page to make easy for user enter input.
Nathaniel_C Super Contributor
Super Contributor

Re: I have issue with parameter

Hi @ali_a ,

Lets reach out to @ImkeF who is a genius with Power Query.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

ImkeF
MVP

Re: I have issue with parameter

y If my understanding is correct and the parameter shall be used to filter the Power Query query that gets the data from the SQL-server, then I'm afraid that it's not possible with SSRS.

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (1,364)