Pre-filter ODBC data

Kaladin · ‎05-31-2023

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!

MFelix · ‎06-01-2023

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

Regards

Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português