Forum Discussion
Self 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.
one document has fields like id, Partition key, col1,col2 ....
another document has fields like id,partition Key,col1,col2 etc.
I want to have a separate table where the document1.partition key = Document2.PartitionKey2
will it be possible?
this should be done in power query editor
Thank you
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.
2 Replies
- amitchandak
Super User
PBILover , if you want to create a hierarchy and use
Other wise you have duplicate the tables and create join
- V-lianl-msft
Community Support
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.