Some of these tips I picked up from different tutorials and some I was able to figure out myself. And indeed, they help improve refresh of the query. 😃

For Folder Contents portion, could you create a tutorial on how to do it with Sharepoint Folder Path? Thank you for these tips! Very helpful!

These tips are absolutely essential and apply way over importing data from multiple csv/excel files. That’s what any sql, bi, data analyst should know and apply🎉

Thanks Chandeep! Awesome as always

Dear Chandeep! I suggest, You could also make additional videos on the power query optimization options as discussed in the video. Please give me your suggestion. I have a problem with the notebook I use at my work. It has an old i3 cpu, 8GB of ram and use Office 365. Dozens of (currently 80 files) csv files need to be processed. Their individual file sizes are approx. 800 MB and the number of rows sometimes exceeds 1 million per file before cleaning. The files are distributed in directories. Imagine that there are cities, stores in the cities, products in the stores, and finally sales data for each product in the stores per customers. Should I read the individual files and then combine them, or should I read the main library? Than filter the necessary data types? Should I store the queries in memory or load them into excel pages? What if there are more rows than 1 million? How should I handle large amounts of data? Maybe I should switch to the MS Access program? Or should I upload all csv files to SharePoint and read them from there with PoweQuery?

Exellent1!!

Great one!!! Loved it.

Good advice on an important topic 👌

Btw, I believe you can transform a subset of the data (like sample file in the transform step) with power query, then convert these power query applied steps into SQL to apply to the larger dataset.

Awesome as alwys🎉 please can you make a video on snowflake database data load to power bi and best practices for handling huge database in power query... Thanks

Hi, How to Save All the custom functions from one pbix file as a file and import those custom functions into other pbix files?

Nice work Chandeep :)

It’s simpler to control formatting with xlsx files than csv - especially with leading 0’s

Chandeep, did you say you can do **Incremental Refresh** when files are saved in SharePoint?! 🤯 Can you point to where I can learn how to do that because that would be a game changer for me!! 😁 Thanks!!

Hi! Very nice video. I have one question, what is the best approach to work with excel files that are generated in different languages?

One small question. Even though csv is a better option than excel when it comes to raw data but their file sizes are quite higher than excel. In older Office, I have seen csv s to be quite smaller in sizes when I would convert them from Excel but it doesn't happen nowadays. How can we address this?

how about savings excel files in binary - xlsb it help with refreshes

I have a question. Do you have a video on how to get data from folder without combining the files, but creating separate queries for all of them?

Does PQ have some way to look how much space(?) does it take to execute each step?

How to merge multiple files, not combine? Do you know The solutions to merge more than 2 files/tables?

So basically he is saying how to make things unnecessarily complicated