Extracting Text/CSV Data Using Text From Example in Power Query!

Learn how to utilize the new Text from Example feature in the Power Query Editor within Power BI Desktop.
VIDEO CHAPTERS 🎥
0:00 - Start of Video
0:06 - Content Intro
0:38 - Start of Demo
1:07 - Creating New Query
2:56 - Text/CSV by Example Result
LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
HAVENS CONSULTING PAGES 📄
Home Page - www.havensconsulting.net
Blog - www.havensconsulting.net/blog-...
Blog Files - www.havensconsulting.net/blog-...
Files & Templates - www.havensconsulting.net/files...
Consulting Services - www.havensconsulting.net/consu...
Contact & Support - www.havensconsulting.net/conta...
EMAIL US AT 📧
[e-mail]
#PowerBI #PBI #microsoftpowerbi #HavensConsulting #powerplatform #microsoft #businessintelligence #datascience #office #data #digitaltransformation #dataanalytics #tableau #excel #powerapps #datavisualization #dashboard #sharepoint #python #bi #analytics #cloud #azure #bigdata #sqlserver #software #sql #dynamics #dataanalysis #yammer #microsoftpowerbi #onedrive #machinelearning #bhfyp #powerbidesktop

[@zeisslaimen1]

very good

[@canirmalchoudhary8173]

Absolutely amazing feature!

[@HavensConsulting]

It really is!

[@papachoudhary5482]

Thanks!

[@sreeshinet]

beautiful

[@tubeitz]

Amazing feature!!!

[@HavensConsulting]

One of my favorite new Power Query features :)

[@solidoffortitude]

This is a feature in most of the enterprise ETL tools, like ODI. It's needed for processing mainframe format extracts, where often one data record is one file and you need to process millions of them by a template. What MIND-BLOWING is that Microsoft is offering it COMPLETELY FREE! This feature will be outstandingly useful in conjunction with Folder, or SharePoint Folder as data source to combine multiple files in one table.

[@HavensConsulting]

Power Query is such an amazing tool that gets included with Power BI :)

[@ncbshiva]

Cool

[@marketgrunt]

Easily the best feature of the August 2020 release.

[@HavensConsulting]

It's really a way to see the "power" of Power Query

[@123jamalq]

Will it work when we have different rows number? in your case there are 10 rows for each dataset.

[@HavensConsulting]

I'm still learning the abilities of it, I'd recommend just giving it some data and see how it creates the table :)

[@vijayvizzu1]

Nice tip, can we do it for other file types too (.pdf)

[@HavensConsulting]

This only works with TXT or CSV files for now

[@alfredsfutterkiste7534]

Great if you need it but here's hoping you never get data in that shitty format :D