Forum Discussion
PBILover
Helper V
Helper VSelf Join in power Bi
Hi, I have cosmos DB data where data is in different document formats. I want to use the column of the main document to connect another document from the same container in a power BI . For e.g. o...
Hi PBILover ,
Extract document1.partition key column as a table, and then create a function and invoke it. You can refer to this blog:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super UserPBILover , if you want to create a hierarchy and use
Other wise you have duplicate the tables and create join