Forum Discussion
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 al...
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.