Creating a query based on the first 8 characters

[JimWorld]

I have a table that containes all of my sites information.   Each site is given a unique device prefix. ie caazucmp.  All of the network equipment that this site will start with these 8 characters.  How do I link this table with my device table based on the first 8 charcters in Power BI.  It is an easy task in SQL,  but I having a hard time finding a solution in Power BI.

Thanks for your help

[wdx223_Daniel]

you need add a calculated column in the table

DeviceID=LEFT(Table[ColumnName],8)

then you can create the relationship with it.