Forum Discussion

mcolb88's avatar
mcolb88
Helper III
5 years ago

Paginated Report Parameter No Relationship

I built a paginated report that has two parameters. Fiscal period is a dataset parameters, which is used in the DAX for the dataset and works fine. However, a second parameter ReportStyle is from a disconnected table that affects only the report style. It's used in formatting expressions in the RDL and has no relationship to the dataset. On my Power BI page with the embedded paginated report visual, I have equivent slicers to pass to report parameters, however when I try to add the value to the paginated report visual parameters, I get the error below and can not add it to pass to the RDL.

 

"Can't display the data becuase Powerr BI can't the relationship between two or more fields. "

 

Is there a workaround or is this a feature request. I believe this is a valid use case. We should be able to map a disconnected value to a paginated report variable. How is this different from mapping parameters between linked paginated reports? Its up to the developer to use the parameter appropriately in the RDL.

 

In the meantime, I have had to expose the RDL parameters by turning on the Toolbar > Parameters setting in the visual. I suppose to avoid confusion I could hide the fiscal period parameter as to not get out of sync with the page slicer, but then we wouldn't be able to use the report directly in the service.

 

Any suggestions are appreciated.

 

Thanks

Need Help

2 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    4 years ago

    I just ran into this and managed to fix it by creating a dummy fact table that both parameters filtered.

     

    DummyTable is just a single row with a Date and ID value.

     

    I don't know why parameters necessarily have to be "related" but this seems to work.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi  mcolb88 ,

    You are trying to use two or more fields from tables that are not related. You need to remove the unrelated fields from the visual and then create a relationship between the tables. Once you have done this change, you can add the fields back to the visual. Refer: Create and manage relationships in Power BI Desktop 

    In this case, there is no relationship between the columns in your table, such as one-to-one or one-to-many. They can all be filtered by a certain column.

     

    You can refer this simliar issue:  Error: Can't determine relationship between fields  

     

    Best Regards,

    Liu Yang

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