Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Request Help with Creating a Report using different tables

Dear All, I request your Help in creating a report from different tables. I have six tables namely BusinessCategories, BusinessPermits, BusinessRolePermit, BusinessRoles, BusinessUserRoles, & Busin...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Anonymous,

     

    The table "BusinessRolePermit" could be redundant. Try it like below.

    Request_Help_with_Creating_a_Report_using_different_tables

    There seems some errors in your relationship.

    Data_Model

     

    Best Regards,

    Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Rnagalla,

     

    I afraid your mode isn't the best practice in Power BI. Please check out the demo here. Just like in the Data warehouse, one (or many) fact table with many dimension tables. 

    1. Merge two tables to get a fact table. 

     

    1

    2. Recreate the relationships. It's a star relationship. If we want to see the details, we can add the dimensions. 

    2

    3. Almost all the fields can be added into the table visual now.

     

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

The table "BusinessRolePermit" could be redundant. Try it like below.

Request_Help_with_Creating_a_Report_using_different_tables

There seems some errors in your relationship.

Data_Model

 

Best Regards,

Dale