Forum Discussion
Referencing a table and column in SQL statement for inner join
Hi there I have a HUGE dataset over 10 million rows and a small dataset of 2501 rows. I need to do an inner join from the small to the large - so I only get matching rows from the large dataset ...
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?