How to create multiple DB starting from a single DB?

[MusaLU8990]

Hi all,

I'm new to the Power BI world, and I was trying to understand if it's possible to start from a database and create N sub-databases that will be automatically updated if new lines are added to the original one.

See the below example:

Let me know if you have any advice!

[v-stephen-msft · Accepted solution]

Hi @MusaLU8990 ,

You can use "Reference" to copy the other three tables, and then filter the three tables you need, and when the data of your main table is updated, the other three tables will also be updated.

Referencing Power Query queries - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[MusaLU8990]

yeah thanks ! seems work.

May i ask another think: this new table that has been create, is it something that i can use to run some query? e.g.

The new table created (the reference one) should be enrich taking data from other tables.

Thanks Luca

[v-stephen-msft]

Hi @MusaLU8990 ,

Yes, it's possible. You could learn about the Merge Queries.

Please kindly refer to
Merge queries overview - Power Query | Microsoft Learn

You can merge two tables directly by a matching column.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.