relationship

[Krzysztof1]

Hi Can I create relationship between tables with only text data ( no values)?

[rajendraongole1 · Accepted solution]

Hi @Krzysztof1 -Yes, you can create relationships between tables in Power BI based on text data columns, even if the columns do not contain numeric values.

ex: i have taken empl with text data and summar with text and one date field. we can do it. 

if you have any reference data please share it. 

Hope it helps.

[Krzysztof1]

Hi Many thx for the fast response. I had the problem when I was trying set up pivot table on Power pivot excel. In Power bi it works Thx

[Idrissshatila · Accepted solution]

Hello @Krzysztof1 ,

based on the common text field.

[Krzysztof1]

Thank you I had a problem in Power Pivot in Excel with selected unique columen with text but when I used Power bi it works Thx Greetings from PL

[rajendraongole1 · Accepted solution]

Hi @Krzysztof1 -Yes, you can create relationships between tables in Power BI based on text data columns, even if the columns do not contain numeric values.

ex: i have taken empl with text data and summar with text and one date field. we can do it. 

if you have any reference data please share it. 

Hope it helps.