Forum Discussion

Hussein_charif's avatar
1 year ago
Solved

Paginated report parameter

i made a parameter in my paginated report to hide/show columns, the user chooses what column he wants to show/hide and based on his selection the columns are displayed on the table.

i am trying to use that paginated report in my power bi report, but when i am prompted to set parameters for it, i use my field parameter that i have in power bi to choose between columns to show/hide, but i have to choose 1 column from the parameter. here is a picture of what im getting :

 

 

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, Hussein_charif 

    You must ensure that the parameter data types of the paginated report are the same as those of Power BI.

    Your error occurs when the data type of a column does not match the paginated report parameters:

    If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
    Thank you for your patience and look forward to hearing from you.

     

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, Hussein_charif 

    You must ensure that the parameter data types of the paginated report are the same as those of Power BI.

    Your error occurs when the data type of a column does not match the paginated report parameters:

    If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
    Thank you for your patience and look forward to hearing from you.

     

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, Hussein_charif 

    I wish you all the best. Previously we have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
    If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
    If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
    Thank you for your patience and look forward to hearing from you.

     

     

    Best Regards

    Jianpeng Li

     

    • Hussein_charif's avatar
      Hussein_charif
      Helper V

      hi Anonymous , sorry for the late reply, i will be testing the solution provided today and let you know if everything works fine.

      thank you!

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi, Hussein_charif 

        Thank you for your patience and look forward to hearing from you.

         

         

        Best Regards

        Jianpeng Li