Create new table from Parent-child relationship

[Anonymous]

Hello everyone, 

I have a main table which looks like below:

id	title	parent id
1	A
2	B	1
3	C	1
4	D	2
(will add more in the future)	...	...

I would like to have mutiple tables auto generate from this main table as:

table 1

id	title	Parent id
2	B	1
3	C	1

table 2

id	title	parent id
4	D	2

table 3....

table 4....

if main table has updated rows, sub tables should be auto generated, so i can create a one to more relationship.

is it possible to achieve?

Thank you!

[Anonymous]

@Anonymous are the tables should be divided based on the parent ID?

If that is the case, then you can duplicate the master table and filter with individual parent id's in it.

We cant auto generate tables in power bi as of now but you have to go by this manual way.