Forum Discussion

brendandalyp's avatar
brendandalyp
New Member
4 years ago
Solved

Report Builder Parameters

Hello,

I have a paginated report connected to a published pbi dataset in a premium workspace. I am trying to add parameters to filter down the dataset so its not too large and fails on the load. I know how to do them with stored procedures in SQL, but not with a pre-existing pbi dataset. I have tried creating a parameter so far and it initially loads

however when I go to view the report I get this error

The parameter <pii>owninglocation</pii> is not referred in the query.
----------------------------
Query execution failed for dataset 'DataSet1'.
----------------------------
An error has occurred during report processing.
----------------------------
An error occurred during local report processing.

 

My dataset is built using a DAX query against the pbi dataset. Is it possible to add a parameter to this report that works, if so how would I add it. I hav

 

 

Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi brendandalyp ,

     

    This is because your parameters are set incorrectly. Please refer to this document to set the parameters of published dataset.

    SQL Server Reporting Services Report Builder with DAX Query Support 

     

    This is the result of my test:

     

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

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

     

2 Replies