Paginated Report making the Cartesian product despite of correct relations among tables

[zebra]

Hi I have a very simple query about paginated report behavior. I have a three tables in power bi desktop with the following data as shown below

Person Table	Person travel History
	Reason

The relation among these tables are follow

When I created the paginated report using the published dataset, Its shows me incorrect data as shown below. The paginated report shows that it is making the Cartesian product among these tables.

On further investigation, I found that designer generated the following query.

EVALUATE SUMMARIZECOLUMNS('Person'[Id], 'Person'[Name], 'PersonReasons'[TravelReason], 'PersonTravelHistory'[city], "cnt", [cnt])

Please let me know how to fix it and shows the correct data as we have in the original table according to the relation.

Thanks

zeebee

[lbendlin]

What is your reasoning for separating the Travel History and the Reason tables?  Shouldn't they be a single table?

[zebra]

@lbendlin 

this is how I recieve the database, secondly there is no relation in between these tables. it may possible that one of these table have entry and other do not. the important there here is both are child of person table.

[lbendlin]

You can have a Reason entry without a corresponding Travel entry?

[zebra]

there can be travel entry without reason entry.

[lbendlin]

combine the tables and accept that the reason field may be empty

[zebra]

would you please provide the complete steps or better to provide the pibx file and rdl files for better understanding?

thanks

[lbendlin]

[zebra]

Please provide the rdl file ( paginated report file) that uses power bi data set.  its work well in pbix file.