Excel Magic Trick 1386: Power Query to Import & Append Large Text File in Power Pivot Data Model

Download Files:

Using Power Query (or Query in Power BI Desktop) see how to Import Big Data Text File & Append to Bottom of Data Model Fact Table. We use Excel Power Pivot Data Model in this video, but it is the same in Power BI Desktop also.

[DougHExcel]

Thanks for the video Mike. 7 + million records! Really shows the power of PowerQuery!

[EricGiroux]

hi Mike, can you imagine, I'm actually at Walt Disney, yet still enjoying your video while the girls're sleeping. Thank you very much! 😆

[himanshudalai]

Great learning !! Thank you Mike for this awesome video !!

[lisat]

Thanks !! Always find your videos very useful and i get a lot out of it !

[zaighamuddinfarooqui]

Impressed. You are very quick to release 1st episode. :}

[LeilaGharani]

I love this series! Can't wait for the next one : )

[ashokchomal]

Sir your all videos are awesome and we learn something new from your videos. can we import Excel data into Tally? plz make a video on it. it will be very helpful me if you make it.

[prasadk]

Sir Mike you are my Excel now I have a business problem were I need to append a single table daily and also want to track the changes with a added field called "Last Refreshed when you have time please help me, I also believe it will be beneficial to lots corporate people who face this challenge daily....Thanks!

[larryogunbanjo]

Great stuff.. Please help..When I upload in the Power Query editor, the dates are shown as ABC and I get some errors while trying to convert to Date.. I am following exactly whats being done using Excel 2016.. Please assist

[rjbush]

Hi. can you use power query to export a worksheet or data table to a fixed length text file. I've seen the merge columns but it doesn't seem to keep the field length correctly.

[brianxyz]

You said it took awhile to append the new records to the existing table. Do you remember how long it took?

[Joshi]

I m importing data but some field are unable to show in power pivot