Forum Discussion

PBILover's avatar
PBILover
Icon for Helper V rankHelper V
4 years ago
Solved

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

2 Replies