Forum Discussion

MusaLU8990's avatar
MusaLU8990
New Member
2 years ago
Solved

How to create multiple DB starting from a single DB?

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 adde...
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
MusaLU8990
New Member
2 years ago

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.