Forum Discussion

Kaladin's avatar
Kaladin
Frequent Visitor
3 years ago

Pre-filter ODBC data

I have an ODBC connection provided by a vendor and i am pulling in the data into powerbi. One of the tables has 164,000 rows. I am doing some filtering in powerquery but on refresh it will pull in all the rows and then filter down to 14,000. Is there anyway to pre-filter the ODBC query so i dont need to pull in so much data that is uneccessary? I tried to search the forums but i could not find a suitable solution. Thanks! 

Need Help

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    3 years ago

    Hi Kaladin ,

     

    If you are using and ODBC connection you can do a SQL query in this case and taking into account that you did the filters on PQ if you click on the last step of the PQ you should have an option to see Native Query that will give a SQL string that you can use directly on the first step to replace your calculation on PQ.

     

    https://www.youtube.com/watch?v=eVDIHG4dflM