Join my M course Today ↗ - goodly.co.in/learn-m-powerquery/ Download the Excel File used in the Video ⬇ - goodly.co.in/combine-data-from-multiple-sheets-into-single-excel-file Combine Data from Multiple Excel Files with Dynamic Columns & Sheets - kzbin.info/www/bejne/oaXKlXeGg72cg8ksi=Q2rFHpvbdD6haMs1
@AK-ij9ilКүн бұрын
Hi Chandeep Goodly, Is it possible to retrieve 3lakh rows table via API Calls and used this as a Data source in power BI?
@msantosh122012 сағат бұрын
Hi Chandeep, Are there any discount coupons/code available that I can avail for your M code course.
@wildecorrea647710 сағат бұрын
You're the best in Power Query! Thank you for sharing the file from the video!
@vl21i21 сағат бұрын
Thanks for the detailed explanation of the steps and their functions. After I learnt how to dynamically read the files using File.Contents my PQ steps are clean without any dependency to sample queries. ❤ the way simple M codes help the data cleansing that too before loading the data
@GeertDelmulleКүн бұрын
Good video, Chandeep, and I will repeat: List functions are the hidden power tools of the M language. ;-)
@lmk00110 сағат бұрын
We get junk data all the time. This is very cool
@chrism9037Күн бұрын
So great, thanks Chandeep
@nazarkamal8831Күн бұрын
Amazing
@cristhianramos49309 сағат бұрын
Chandeep we need a video where you explain how to still just one row when there´re many rows with the same information but for example only 1 columns with different dates. Would be like group but with conditions. Thank you for your content
@williamthedataprof12 сағат бұрын
Thank you buddy for the share. However, let' just say there's always a sacrifice one has to make or be aware of. In this case, being the owner of the data, I should know at least2 or 3 headers that I can anticipate and check for a row that contains such. Otherwise, the method you illustrated, in my opinion, is more troublesome because it assumes the data rows have no chance of missing data...
@Faisal63045Күн бұрын
Thank you for sharing
@alexrosen8762Күн бұрын
Thank you Chandeep! How is this different from combining data from multiple workbooks into a single sheet/excel file?
@rkshivay4681Күн бұрын
Great 👍
@vikashparihar83669 сағат бұрын
What if we need to merge Sheets with multiple workbooks to multiple workbooks of a master sheet. Like, Workbook 1 of sheet 1,2,3 will be merged with Workbook1 of Master sheet. Similarly other workbook will merge with according workbook of Master sheet. I hv 3 sheets each with around 15 workbook. And requirement is to have a master sheet with 15 workbooks.
@RollacoastertycoonКүн бұрын
Does this work for multiple api calls to a single data flow like a loop When I try it says can’t because it’s dynastic
@굿찬스-q4yКүн бұрын
What if there is junk column ?
@dimmitrioКүн бұрын
In this case "null" method will not work correctly, need to use method when you look for exact column name like [Date].
@dimmitrioКүн бұрын
But seems if we work with Tables in the column and not the sheets there have not to be junk columns.
@brightonalbert323712 сағат бұрын
thank you, but if you have more than 1 csv files
@ebenezerasare9934Күн бұрын
the download file is not working
@DJZGКүн бұрын
There's a workaround but you need to know a bit of html. Or for the purpose of the exercise, build your own custom table with few sheets and few rows of random data.
@nazarkamal8831Күн бұрын
❤❤❤ Excel
@zbatevp-vlogs610Күн бұрын
what I currently hate about power query is that it is slow. It's beautiful but its just slow.
@RichardJones73Күн бұрын
And sometimes buggy, like you can't select drop down options sometimes
@descendantsoftheheroes_660Күн бұрын
kya fayda itni skills ka ...jab tak north indian ko hinglish me nhi provide kr sakte
@GoodlyChandeepКүн бұрын
www.youtube.com/@desigoodly :)
@descendantsoftheheroes_660Күн бұрын
@@GoodlyChandeep dax ka module b complete nhi hai vha
@GeertDelmulleКүн бұрын
I don’t speak Hinglish, but I do speak Denglish. LOL! :-)
@descendantsoftheheroes_660Күн бұрын
@@GeertDelmulle I am discussing the individual who owns the channel responsible for posting the video.