How to resolve Power BI DAX Join error?

+1 vote

I am trying to join two tables which are based on a column name 'User_Id' for both the columns  

'User_Id' column is present in both the tables, but unfortunately, an error is popping up.

This error is occurring at the same time ie NATURAL LEFT OUTER Join and NATURAL INNER JOIN.

How do I resolve this?

May 14 in Power BI by anonymous

edited May 15 by Omkar 29 views

1 answer to this question.

+1 vote

Sample Table Used Here:

Table1: Partner_ID, User_Id

Table2: User_Id, User_Name,UserEmailId

According to this, you can't have columns with the same names when you try joining tables in DAX. 

You need to use different syntax like SELECT COLUMNS to not change the names of the columns 

answered May 14 by Avantika
• 1,460 points

edited May 15 by Omkar

Related Questions In Power BI

0 votes
1 answer

How to assign Power BI license to a new user

The assign license method of MS Graph API might ...READ MORE

answered Sep 25, 2018 in Power BI by Kalgi
• 37,320 points
46 views
0 votes
1 answer

How to publish .pbix report from power bi desktop to power bi service directly?

To save powerbi file directly to report ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 37,320 points
135 views
0 votes
1 answer

How to add an image to power bi report – power bi web

There are visuals (e.g. table) that can ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 37,320 points
28 views
0 votes
2 answers

Power BI service throwing 403 error when using token to embed Power BI report

To add to @Kalgi's answer, Also make ...READ MORE

answered Oct 3, 2018 in Power BI by Nilesh
• 6,900 points
429 views
0 votes
1 answer

Install Power BI Desktop

It’s a pretty simple process. All you ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 37,320 points
33 views
0 votes
1 answer

Few tips before I start creating Power BI dashboard

It’s always advisable to begin with the data ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 37,320 points
71 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 37,320 points
45 views
+1 vote
1 answer
0 votes
1 answer

How To use R Integration in Power BI?

Hi,  There are a lot of packages available ...READ MORE

answered May 2 in Power BI by Avantika
• 1,460 points
45 views
0 votes
1 answer

How to sum a data table in Power BI?

It's a good practice if you avoid ...READ MORE

answered May 17 in Power BI by Avantika
• 1,460 points

edited May 17 by Omkar 52 views