Forum Discussion

allen3just's avatar
allen3just
Frequent Visitor
6 years ago
Solved

Remove Duplicates in One Column in Direct Query

Hello all,   I need to filter out the duplicates from one column in a direct query in power query so that my DAX measures for another column doesn't take duplicate values. How would I go about doin...
Need Help
allen3just's avatar
allen3just
Frequent Visitor
6 years ago

Hello,

 

I have already figured out the solution thank you for checking up on this. One minor question and I'm not sure if this is the place to ask. If I have a direct query and I'm doing the filter by today in power query, I notice that the query takes a long time to load. Is it better to do all my filters before doing the filter by today or start with filter by today before doing the other filters?

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi allen3just 

If you have "today" filter in Power Query to limit the data loaded into Data model, then have filters in data model like (visual level filter, report level filter,, ect),

In this scenario, doing "today" filter before others is useful.

 

If  "today" filter and your other filters are all in Power Query, there is no difference to doing it before or after.

 

If your requirement is to limit only today's data showing on Power BI, 

For a better performance, you can limit data when connecting with SQL Server,

you could use SQL Statement in Connection window/code.

https://community.powerbi.com/t5/Desktop/How-do-I-pass-parameters-to-my-SQL-statement/td-p/118716

https://community.powerbi.com/t5/Desktop/Direct-Query-Filters-in-the-report/td-p/512860

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • allen3just's avatar
    allen3just
    Frequent Visitor
    6 years ago

    Thanks for your help!