New columns of table type after join

[javedbh]

I have three tables (Company, Purchase, Sale) in sql server database. Parent/child relationships exist between them in sql server. I imported two of them (Company, Purchase) in power bi. Both tables imported successfully and power bi has linked them as well. When I go in “Edit Queries” form, I see two columns named “Purchase” and “Sale” in Company table but these columns don’t appear when I try to create a column or measure. Why they are there and how to use them?

[v-shex-msft]

Hi @javedbh,

As ImkeF said, the table type can only analysis at query editor side, if you want to use them at report view, you need to expand them.

For example:
Right click to create a reference query, then click on the table which stored in the records to navigate to this table.

Then you can create the relationship at report view side.

Regards,

Xiaoxin Sheng

[ImkeF · Accepted solution]

You can only use them in the query-editor where you use the M-language.

In the table-view where you're using DAX you can only refer to columns with "single values" in them.

You can flatten Parent-Child-hierarchies in the query-editor using M like this: http://www.thebiccountant.com/2017/02/14/dynamically-flatten-parent-child-hierarchies-in-dax-and-pow...