I have issue with parameter

[ali_a]

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

[ImkeF]

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.

[Nathaniel_C]

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

[ali_a]

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]

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