Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors