Get only the rows you need in Power Query from your files.

In today's video I will show you how to find the rows you need and import those instead of importing everything and then filtering them.
Chapters:
00:00 Explain use case
00:40 Import only rows that contain a word
02:20 Get rid of tables that do not contain our word
03:10 Find words on only one column of the table
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

[@srikanthp1643]

It's completely advanced especially the way of explaining thank you.

[@sukoi2113]

Way smarter..i like such magical operation. Thanks a ton.

[@thegrilow]

Thank You Ruth!! You´re awesome!

[@AprendaWell]

Thx for sharing Ruth... It's simple amazing

[@Maartenmarsje]

Great video Ruth! Thanks

[@MartinKuzmicz]

Great video. Thanks.

[@srinivaskundan7031]

Hey Ruth, I'm very much inspired with you videos. Can you make a video on showing no of days spent in a project on a Monthly basis split

[@EricaDyson]

Hi Ruth... been off line for a while. so nice to check back in for more helpful PQ stuff. Thanks so much.

[@CurbalEN]

Hi Erica, hope everything is well with you and welcome back!

[@HachiAdachi]

(M)agic Tuesday! 😉 Bunch of useful stuff here! Thanks, Ruth!

[@CurbalEN]

😇

[@emmafeng55]

Nice tool! Thanks Ruth! 🥰

[@CurbalEN]

My pleasure 💛

[@vida1719]

Yes, it was useful to know this function

[@CurbalEN]

Fab 🥳

[@singhalmonica]

Thanks for valuable info. Pls guide me what to do if our txt is not always in any perticular column.

[@suneel3011981]

Hi Ruth, Could you please help on how to filter data at source, i mean before loading to the power query editior . If source has got millions of data , then i need to filter at source with certain date and text conditions

[@nyahmusic]

So would this be a lot more processor efficient than loading the tables and then applying a filter? It seems that the query is still having a search through the entire table before loading it, but this would be a faster approach?

[@sauabhyankar]

It still searches through the entire table. Is the understanding correct ?

[@CurbalEN]

It has to, to find all the matches.

[@andreslonardi5401]

Hello Ruth. In the latest versions of Power BI, it stopped showing data while loading. Are there any new settings to enable the display of data loading from Power Query to Power BI ?. Thank you!!

[@hugomancera9330]

Hey Ruth, I love this approach, I just have one quick question and on how to do it!! Can we use a view that is coming from SQL or snowflake and how? Thanks!!!

[@hugomancera9330]

omg!! hahaha I just try it and worked!!! I did it based of a snowflake view.. Thanks Ruth, this works like a charm!!!

[@lucassardo]

Hi Ruth, really nice video, just a question, how this works in terms of performance with big amount of data ? thanks

[@CurbalEN]

Power query is not the best technology for big data, use live or direct query instead or if you have the 💰 hybrid tables.

[@smartwork4768]

Hello Mem, I never miss your any of the videos and you are absolutely amazing in this. Well, i have one query if you could guide me here, - Let's say i have load query from folder and i have multiple files available in that folder belongs to every month sales and let's say i have built one report and loaded in excel using power query. - Now after deleting a few files from folder, how could i keep old file data in excel where i have loaded the query besides that file get removed from folder? - as we know after refracing of query it would load fresh data only in model. basically, i want to preserve old data also in my excel where i have load the query. Thanking you in advance.

[@alexkim7270]

Hey Ruth this is great. Just a question, do you know of a way where I can find text length on only one column to return? So instead of filtering "golf", I want to filter text length = 4.

[@CurbalEN]

The docs say that you can only put text , but sometimes it allows an expression, try it!

[@alexkim7270]

@@CurbalEN meanwhile I also found something else I can do, which is Table.SelectRows. It's a completely different approach to what you're sharing but hey, your video led me to the right solution. So HUUUUGE thank you for that, Ruth.

[@CurbalEN]

🥳🥳🥳

[@gakobok626]

The crop on the video made it a little hard to see the entire screen especially the formula bar...but it makes a report I had to do today so much easier next time 👍🏾 thanks.

[@CurbalEN]

Sorry I thought you could see the formula bar at all times :(

[@mikelast8468]

Can you tell that this approach works faster compared to just filtering the data that you need with filter step in PQ?

[@CurbalEN]

Probably it won’t be faster as it looks on all columns for the word, by test to be sure.

[@HEMENDRAPARIDA]

How can I select on a specific tab/sheet from a large file with many sheets

[@nyahmusic]

So this would be more processor or time efficient than loading all the tables and filtering down correct?

[@CurbalEN]

Maybe, performance is dependent on many variables. Do it and test it to be sure.

[@gildasmadore8761]

@@CurbalEN Hi Ruth, thanks for this video. I have to test the performance.

[@CurbalEN]

Let us know!

[@pythonking1705]

you are the best ;) but i have a question how can i have just power Query VIDEOS in your channel ?? THANK YOU

[@CurbalEN]

Yes, look for the power query playlist: m.kzbin.info/aero/PLDz00l_jz6zxF_OSmQhWBCVmQOaROoxWj

[@pythonking1705]

@@CurbalEN thank you 😊 🙏 💓

[@ybbrandsandads]

Someone sent me data in excel file,which i saved as a copy and used that as a source of my powerbi report,and sent it to him,now can he update data directly into his excel or does he have to change data source, (i haven't altered the excel data).

[@oscariglesias1268]

Hola, el nombre de las columnas se pierde, ¿ qué habría que hacer para mantenerlo? Gracias

[@siddharthanich]

When I tried to download the files to practice, its taking me to Synology Drive. I there any way I can download?

[@CurbalEN]

Use the desktop to download them

[@harishstark]

Scheduled refresh is slow when compare to manual refresh You guys know anyother way to do automatically using other apps Like power shell or python

[@SairamBalasubramaniam]

unable to find the files related to this video

[@davidferrick]

BUT, you end up filtering out the column headings.

[@CurbalEN]

True if the source is excel where headers need to be promoted, will work well on other sources. For excel you can dynamically replace column headers if you have many columns.

[@MartijnPotman]

You need to be Microsoft Excel to ask a user to create a new column to conditionally filter rows.

[@baastech7840]

can i ask u somethings private ? how much money u make from you tube and try to expline how its works