Forum Discussion

Tooshay's avatar
Tooshay
Regular Visitor
8 years ago
Solved

How to filter amongst two tables from SQL?

Hey All,   I have two tables, with a layout like below (from a SQL database)   Table A (filter applied so only some ID remains) ID 1 3 5 6 8   Table B has characteristics for the entry in...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Tooshay,

     

    The established relationship between TableA and TableB will affect each other in Report View. In other words, such a relationship doesn't filter table records in Query Editor, and doesn't affect the loaded row numbers. Each time, all rows of table will be loaded to desktop, then, filter applies in visual level on report page.

     

    In your scenario, if you want to filter data before loading to desktop, you could write SQL query in SQL statement.

     

    Best regards,

    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Tooshay

 

If you maintain 2 seperate queries then Power BI brings data from both table based on filters and based on Dax usage the joining will happen in PBI only.

 

So considering your table size, you can Join table A with Table B in Query Editor itself , so that the join will heppen in DB itself.

 

you can have all requied columns in the new table, so you wont lose any data here.

 

Thanks

Raj