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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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