Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 ...
Need Help
Mariusz's avatar
Mariusz
Community Champion
7 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous  did you ever figure out how to do this?