Forum Discussion

Max_powerbi's avatar
Max_powerbi
New Member
3 years ago

RELATE EACH ROW FROM MAIN DATBASE TABLE TO SPECIFIC TABLE FROM OTHER FILES

Hi Everyone

 

 

I'm new to Power BI and I need some help. I am making a dashboard for project management (Civil or Construction Projects). I have a Database with all the projects and it has the general information of each one (Project Number, Name, client, Project Value, Term, etc). For each project it would have particular tables with the list of invoices and their values, personnel of each project, among others. My questions would be:

1. How do I relate the main database where I have the project list with its project number with each table (invoices and personnel). The dashboard used segmentation with unique value to see the information of each project.

 

2. Taking into account that the project list is updated, is there an automatic way for the invoices and personnel tables to be added as data sources automatically?

 

Attached an image with a simple example.

Thank you so much!

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Max_powerbi ,

     

    Power BI likes the star schema model. So the first step needs to be to understand this and move closer in that direction.
    Understand star schema and the importance for Power BI

     

    You might consider grouping all fact tables (adding ProjectID fields) and Append/Merge them together. Then create relationships with the dimension table.

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data