JOIN

[Satish_Kumar]

I DO NOT WHAT IS THE ISSUE WITH POWER BI.

IT NEVER LET ME DO ANY JOIN WITH TWO TABLES WHO HAS COMMON FEILDS(PRIMARY KEY)

HELP ME OUT.........................

[v-yulgu-msft]

Hi @Satish_Kumar,

To use NATURALINNERJOIN function, you should create a relationship between these two tables. Otherwise, it will prompt error.

Thanks,
Yuliana Gu

[Satish_Kumar]

@v-yulgu-msft I already made the relationship.

[v-yulgu-msft]

Hi @Satish_Kumar,

Sorry for the delay.

Which version of Power BI desktop did you use? In my local environment, I could not reproduce your issue. The NATURALINNERJOIN function worked fine for me.

And if you join these two tables using other functions, like CROSSJOIN, NATURALLEFTOUTERJOIN, did the error message persist? Also, test the NATURALINNERJOIN function using some other sample data to check whether this is an issue with this function or there is something wrong with current data you used.

Thanks,
Yuliana Gu