Forum Discussion

ali_a's avatar
ali_a
Frequent Visitor
6 years ago

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

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion

    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's avatar
      ali_a
      Frequent Visitor
      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's avatar
        Nathaniel_C
        Community Champion

        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's avatar
    ImkeF
    Community Champion

    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.