Create relationships using 2 columns as primary key

[pji]

Please allow us to create relationship between two tables using a combination of 2 columns instead of single column, if none of the single columns have unique values. Sometimes it is not possible to create summary tables with unique values for any column.

[v-haibl-msft]

@pji

We can either creating another summary table or using a concatenated column in such scenario.

Please also create an idea in https://ideas.powerbi.com for feature request.

Best Regards,
Herbert

[pji]

Thanks. I did that.

[jthomson]

You could create a column concatenating the two you want to use as a workaround?

[pji]

That won't help in my case, since I am making a generic template and the base table would be deleted and readded every time. I would like to minimise the effort as much as possible.