cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pstanek Member
Member

Related

Hi. wanted to create calculated column, but I haven´t found RELATED function. How is that possible? I thought, it didn´t have problem with direct query

Výstřižek.PNG

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-huizhn-msft Super Contributor
Super Contributor

Re: Related

@pstanek

What’s the relationship between the table? And do you use Direct Query model? Please share more details or full screenshot for analysis?

 

As I tested, it may be caused by the relationship between the table. The relationship is one -> many, or many->one, Which means that for each row in lookup table you can have more than one row in another table. So it returns an error. Here is a similar thread for reference.

Best Regards,
Angelia

2 REPLIES 2
v-huizhn-msft Super Contributor
Super Contributor

Re: Related

@pstanek

What’s the relationship between the table? And do you use Direct Query model? Please share more details or full screenshot for analysis?

 

As I tested, it may be caused by the relationship between the table. The relationship is one -> many, or many->one, Which means that for each row in lookup table you can have more than one row in another table. So it returns an error. Here is a similar thread for reference.

Best Regards,
Angelia

pstanek Member
Member

Re: Related

It is direct query, but we have streamed data by IT department