Forum Discussion
Filtering before import of data
Hi, I have a on-premise Hive table that has close to 100M records, out of which ~10,000 belongs to a certain category. I would like to import only these 10,000 records using Power BI Desktop. I h...
v-alq-msft
Community Support
Community SupportHi, TANTR
You may try the following steps.
Here is my example.
Plan:
You may create a filter which gets the record with 'Days' = 1.
Then you may right-click the 'Filter Rows' and click 'View Native Query'.
You can copy the code and create a new query to get data from the same data source, and then go to 'Advanced options' and paste the code to sql statement.
Finally you may get a table filtered by 'Days' = 1.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Syndicate_AdminAdministrator
Thank you very much Allan, I had the same concern and I was very useful in your practical way of explaining it to reach the solution.
Best regards
Fabio