Related Articles
Newsletter
Join our blog
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.


-1.png)
Start with the FREE community plan and get your lifetime access to 20+ courses. Get Instant Access Now!
Need help? Talk to an expert: (904) 638-5743
Private Classes
Private deliveries of courses for groups
On-Demand Learning
Beginner to advanced classes taught by Microsoft MVPs and Authors.
Bootcamps
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
Certification Training
Prepare and ace your next certification with CertXP.
Cheat Sheets
Quick references for when you need a little guidance.
Prag Guides
Explore our knowledge base for quick tips on syntax, functions, and more!
Downloads
Digital goodies - code samples, student files, and other must have files.
Blog
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Community Discord Server
Start here for technology questions to get answers from the community.
Career Guides
Breaking into the field? Let these guides help get you started with a plan.
Nerd Guides
Summaries developed in conjunction with our Learn with the Nerds sessions.
Quickstarts
Hands-on training with expert-led collaborative development.
Private Training
Personalized approach for your specific training requirements
Hackathons
Use your own data to take your team's skills to the next level.
Virtual mentoring
Get there faster with your personal trainer.
Enablement
Comprehensive enterprise enablement training for your team.
Admin Hackathon
Tame your power platform environment.
Today’s post is in response to a question I was recently asked. It’s about using Azure Data Lake Store with Azure Data Factory, in particular about the Copy Activity within Data Factory to read data from Azure Data Lake.
Someone asked, If I have some Excel files stored in Azure Data Lake, can I use Data Factory and the Copy Activity to read data from the Excel files and load it into another sync data set (in this case a database)?
The short answer – no. This may seem a bit confusing as we know that you can store virtually any type of file in Data Lake. However, that doesn’t necessarily mean that Data Factory can read or consume files of any format out of Data Lake.
I wanted to explain that key difference today as it’s something to be aware of. To be more specific, Data Factory can consume files from Data Lake if it’s in a JSON format, a text delimited, like a CSV file, or any of 3 Hadoop file structures, those being AVRO, ORC or Parquet files. With any of these formats you can use Azure Data Factory to read those from the Data Lake.
Excel files can be stored in Data Lake, but Data Factory cannot be used to read that data out.
So, that's my quick tip that I hope you found useful when working in Azure Data Factory and Data Lake. If you have questions about either of these Azure components or any other component or service in Azure, we are your best resource. Click the link below or contact us to discuss anything Azure related – we’re here to help.
ABOUT THE AUTHOR
Free Trial
private training
Newsletter
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.
Leave a comment