Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
7 years ago

USERELATIONSHIP

Hi Guys,   I'm newbie at Power BI, probably I'm gonna just shoot my curiosity.   As fr as I know, Power BI has limitation to create relation ship to same table or even it is indirect.  Lets say ...
Need Help
admin_xlsior's avatar
admin_xlsior
Post Prodigy
7 years ago

Hi, 

Thank you for the response.

 

I'm not sure I can merge it, each table each table has it purpose.  And I understand why you are saying need to optimized, especially if you looking at my ResourceCompany Table, and I open for an advice. However just need to inform that these tables is getting directly from OLTP / Transaction database and it is the way they built it.

 

And also we using Direct Query for the fetching method, so understand there might be some function limitation inside Power BI when we create measures or column.

 

To make it clear here is some picture to describe more clear :

 

Hope it is clear out.

 

Thanks,

 

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

Hi admin_xlsior,

 

Actually, you don't need to establish a relationship between Resource and Company. Why? If you want to analyze the Resouce and the Company, the Resource table has everything. You don't need to filter the Resource table from the Company table.

Finally, you have slicers from Company and Resouce to analyze the SalesFact table. For example, if you select BGR from the Company table and select Matt from the Resource table, the result is empty.

Please give it a try anyway.

 

 

Best Regards,