Forum Discussion
check for relation with other table
I want to check if there is one (or more) row(s) in another table (table2), with a relation to the first table. I've found a soltion which I've tryed in my ow model but now I get the error: - The fu...
Hi PattemManohar, I'm a newbie so most certainly I'm doing something wrong, but for now I don't have the 'Create table' available. May it's because I',m working in the DirectQuery-modus? Is there a(nother) way to get this option available?
PattemManohar
Community Champion
Community ChampionUnder Power Query Editor, you can see the Merge Queries option... as below
thanks PattemManohar, I found it.
It appears that the fields aren't of the same type.
Which is strange, because as far as I can see they both are numbers.
I'm gonna find out whats wrong and then try the rest of the steps.