Forum Discussion
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 ...
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,
