How to bulk import PDF files in Power BI (part 2)
Рет қаралды 7,109
5 жыл бұрынIn today's video I will give you more tips on bulk imports in Power BI: Bulk import pdfs, parameters available and more!
#powerquery #curbal #powerbi
Previous video on bulk import: 2:52 • A cleaner, better and ...
M functions covered:
Pdf.Tables: docs.microsoft.com/en-us/powe...
Access.Databases()
Csv.Document: docs.microsoft.com/en-us/powe...
Excel.Workbook: docs.microsoft.com/en-us/powe...
Chris Webb blog: blog.crossjoin.co.uk/2019/02/...
Changing headers videos:
• Managing changing colu...
• Manage headers in bulk...
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
************
What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!
www.amazon.com/shop/curbal
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
@TheVamos777 5 жыл бұрын
Another one is simple txt where you can use Lines.FromBinary("Content") This gives a list so you have to expand to rows or exact into a single cell. Stole the syntax from processing a single file so you could do the same for other supported file types like json/xml and html processing.
@CurbalEN 5 жыл бұрын
Yey! Thanks for sharing :) Comment pinned! /Ruth
@lenzypetty9371 2 ай бұрын
Many many thanks for a great post that was very helpful for me today in an effort to combine multiple pdf files that contained multiple pages. I could not find a single solutions that was explained as simple as you made it...your wisdom from 5 years ago is very much appreciated!!!
@mattmiller07 5 жыл бұрын
Keep up the great work. I really like these quick tips videos. Lots of info in one video
@CurbalEN 5 жыл бұрын
Thanks for the feedback:) /Ruth
@brunof.s.8186 5 жыл бұрын
congratulations for the 20k subscribers! excellent video by the way, i enjoy a lot those "applied" tips in Power Query.
@CurbalEN 5 жыл бұрын
Thanks!! Couldnt be done without all of you. You inspire me to be creative and keep going :) Thanks for all the support ! /Ruth
@implementedgmbh 5 жыл бұрын
Thank you for the Part 2-Video! Again great tips that make PowerBI-life easier! :-)
@CurbalEN 5 жыл бұрын
Music to my ears 😊 /Ruth
@ndjanardhan 5 жыл бұрын
Nice & Helpful Video for Parameters Tips & PDF Files :)
@CurbalEN 5 жыл бұрын
Glad to hear! /Ruth
@HachiAdachi 5 жыл бұрын
Thanks for the follow-up, Ruth! And yay!! for Big 20K!! :D
@CurbalEN 5 жыл бұрын
Yey!! The bigger we get the more and better tips we can share with each other. And huge thanks for your support :) /Ruth
@HachiAdachi 5 жыл бұрын
@@CurbalEN (I just saw Guy In a Cube mentioned you again in the latest video.. :))
@christopherhastings2142 5 жыл бұрын
Great tips!
@CurbalEN 5 жыл бұрын
Yes! Thanks to all for sharing :) /Ruth
@batrarumil 5 жыл бұрын
This is very helpful but I got scenario where I need to bulk import excel table from multiple file. Each dated excel workbook has similarly named table. Is their a way to do that?
@sergipinol3476 5 жыл бұрын
Great tips! thank you so much. It made my PBIs much easier to understand. I have a question: how did you get the context help tooltips on the commands and parameters as you write? Is this the IntelliSense option in preview options?
@sergipinol3476 5 жыл бұрын
Yes it is! I didn't know about this preview feature and it's cool. I got to it thanks to your video. Well, actually it only works on the Advanced Editor, while in your video you have it on the formula editor too... So you probably have a special beta version...
@CurbalEN 5 жыл бұрын
Great! Glad you got that :) /Ruth
@juanaleman7870 5 жыл бұрын
Ruth me encantan tus tutoriales y el dominio que tienes de dax y M. Una consulta veo que utiliza intellisense en columnas personalizada, cómo hace para activarla, gracias de antemano.
@CurbalEN 5 жыл бұрын
Es una de las “preview features”: M Intellisense Y muchas gracias :) /Ruth
@RobertoStaltari 5 жыл бұрын
I had to load millions of rows using an alike approach using CSV files in a SharePoint. Everything worked nicely, but the model file size made the pbix almost unmanageable, so I had to work with a significative subset of the data, then after publishing the model, I put back in the SharePoint all CSVs (12 GB) and let PBI Service do the work (I have also used Dataflows). I wonder if there is a different and better way. (BTW the Table.FirstN function was very handy in the ETL)
@CurbalEN 5 жыл бұрын
I would clean the historical files and move the data to a sql database or dataflow and then join the data with new csv files. /Ruth
@HachiAdachi 5 жыл бұрын
FYI: I just saw a video on a related subject at BI Elite channel: kzfaq.info/get/bejne/q52DrNSF1bKtepc.html
@mohamedchakroun4973 5 жыл бұрын
Hello Curbal Good job I have a question, in powerquery when i insert Pdf.Tables in custom function he gives me an error msg saying " Expression.Error: The name 'Pdf.Tables' wasn't recognized. Make sure it's spelled correctly. how could i fix it????
@CurbalEN 5 жыл бұрын
You need to have ”get data from PDF” preview feature on for it to work. /Ruth
@mohamedchakroun4973 5 жыл бұрын
@@CurbalEN how can i get it???
@CurbalEN 5 жыл бұрын
File >Options>Preview Features > /Ruth
Office Universe
Рет қаралды 8 М.
Access Analytic
Рет қаралды 12 М.