cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Query parameter vs merged table inner join

Opinions and technical solutions greatly appreciated please.

I am building a SQL database query based on query parameters from Power BI Desktop. Users will enter the parameter (text value) which will pre-filter the data brought into the dashboard. Nothing controversial about that.

However, the parameter affects a single dimension table from the database. I have other dependent dimensions, and of course the fact table, that I would like to filter as part of the query too. The affected parameter field is not present in those other tables.

So, I have two options:

1) Amend my SQL queries to include the parameter field in every imported table, and 'filter rows by parameter' in Power Query;

2) Leave the SQL queries as they are, and use a merge function (inner join) on each of the other tables to return only the rows that match the table filtered by the query parameter.

Which of these methods would be most efficient?

1 ACCEPTED SOLUTION
Mariusz
Community Champion
Community Champion

Hi @Anonymous 

I would start with second optoin and if the Query Foliding output is satisfying just stick with that.

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Mariusz
Community Champion
Community Champion

Hi @Anonymous 

I would start with second optoin and if the Query Foliding output is satisfying just stick with that.

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors