Forum Discussion
Referencing a table and column in SQL statement for inner join
Hi Anonymous
You can use Merge Queries, if you getting your data from SQL server it will perform Query folding.
You can check your SQL syntax by clicking on "View Native Query"
Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Mariusz sadly view native query is greyed out for the merge step.
Basically, if I knew how to reference the OverPayment table and the InvoiceId column in a SQL statement, it should work. I've tried Table.OverPayment and that doesn't work either.
I absolutely don't want to import the entire huge dataset and perform a merge within PBI.
Hi Anonymous
Please check how you importing your tables, do you just select them from the list or do you write a sql do it?
Some of the transormations are not suported by Query Folding so its importent to make the merge before you insert any function that can not be translated to a native langage.
Please check this article and video
https://exceleratorbi.com.au/how-query-folding-works/Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.The huge table is on a SQL server, so I can use the SQL editor within Power BI to define what I want before I import it. What I want, is an inner join to an existing table within Power BI.
I have attempted to define an inner join, however I don't know how to reference the Power BI table called OverPayment.
If anyone knows how to reference a table in the SQL query editor, that would be great.
Thanks :-)Anonymous did you ever figure out how to do this?