Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Satish_Kumar
Helper V
Helper V

error in join

 

error1.pngtab1.pngtab22.png

 

8 REPLIES 8
LaurentCouartou
Solution Supplier
Solution Supplier

It looks like both tables in your CROSSJOIN have a column named 'No_'.

 

This is not allowed, because the returned tables would have two columns with the same name.

 

Try to restrict the number of columns that participate in the CROSSJOIN operation with a GROUPBY / SUMMARIZE or use SELECTCOLUMNS to rename some columns.

LuisQuedas
Advocate I
Advocate I

Hi Satish,

 

Do this two tables already have a bidirectional relationship between them? if so, try to remove that bidirectional relationship and try the crossjoin again.

 

Cheers, Luis

@LuisQuedas Nothing Changes it is showing same error.

@Satish_Kumar

 

As the error message said, "No_" column exists in both tables. When using CROSSJOIN() function, column names from table arguments must all be different in all tables or an error is returned. Otherwise it can't do Cartesian. Please verify the columns in both tables. If both contains "No_" columns, you can join these to tables using "Merge Queries" in Query Editor.

 

66.PNG

 

Regards,

 

Satish_Kumar
Helper V
Helper V

 

error1.pngtab1.pngtab22.png

 

Satish_Kumar
Helper V
Helper V

Error while Cross JoinError while Cross JoinTable oneTable oneTable twoTable two

Hi Satish,

 

Can you please repost the screenshots. I can not see anything in the screenshots.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

@BhaveshPatel i already posted the new screen shot.

with new post "Error in Join" just a few seconds earlier.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.