excel power query | how to upload more than 10 lakh rows in excel | power query excel 2016

Power Query is a data connection technology that enables you to discover, connect, combine, and refine data sources to meet your analysis needs. Features in Power Query are available in Excel and Power BI Desktop.

How does Power Query work?
With Power Query you can search for data sources, make connections, and then shape that data (for example remove a column, change a data type, or merge tables) in ways that meet your needs. Once you’ve shaped your data, you can share your findings or use your query to create reports.

How do I get Power Query?
Power Query is available as a download for Excel 2013 and 2010. The underlying Query technology that enables Power Query is also found in the Power BI Desktop, which is part of the overall Power BI offering from Microsoft.
#PowerQuery
#PowerPivot
#Daxformula

Time Stamp :-
00:42 how to get power query on system
01:30 how to upload more than 10 lakh rows in excel
03:30 Index Column in power query
03:48 sort descending in power query
04:30 how to upload CSV file in query editor
05:11 Delimiter in query editor
06:00 what is data type deduction in power query
06:36 how to change data type in query editor
07:40 how to load data in excel through query editor
08:28 import data in query editor
09:12 check data in queries and connection in power query
10:32 check data model in query editor

**********FOLLOW ON**************
______________________
POWER BI

Excel formula

Pivot Table

Excel Interview Questions

Gyan On Tube Excel

[TaslimCostAccountant]

Dear Sir Please mention Classes types like Power Query Class-1 & Class-2
so that we can watch one by one classes to learn step by step

[pankulbaijal]

Great topic sir ji and I am very happy to see that because I didn't know to much about this section definitely will help me learn more, so keep doing the awesome job you are doing. Happy Learning 😊😊

[jayantabhattacharyya]

Dear Sir,
At first I would like to wish you a very happy and prosperous Subho Bijaya.
You have presented a very good and very educative video regarding power query. Waiting a lot more videos regarding power query in near future.
Thanks & Regards
Jayanta Bhattacharyya

[sashak]

Thanks sir for your informative video. I have one query about this video. If you could please specify the series numbers for this query series. Thanks

[Al-hidayahhTV]

Bhai, your explanations are truly worthy..
bhai clients ko rapidly kaise trap krein?

[mahamudtamboli]

It is awesome learning platform, easy to understand, appreciate your efforts. Could you please attach text file of more than 10lakh line item in the description, I'm not able to see that file.

[kishorpanara]

Sir new series ke best of luck and awesome

[meet_mew]

Nice content. If the table doesn't load sheet even using the power query tools, just because the rows are up to 50 million, then is there any other way to load it and save it as a CSV file?

[by]

Hi sir, before loading showing tables 1 table 2 etc show all table.. and showing pop up as data in the preview has been truncated due to size limits reducing the number of coloumns or filtering may load more data..how can I solve this I think more of my data not showing there

[hiteshkumar]

Hi I am trying to work on some data and getting this message.

[MySikender]

Dear Sir am greeting while pasting data form another sheet, The Copy area and the Paste area are not the same size and shape, pls share some solutions.

[DevendraSingh-txpt]

Can we use excel as a data source if data is more than 20 lacs for power BI. Since we receive 50k records everyday and want to create views on power bi for day wise, month wise at least for 3 months or 2 months. In this case, we will have more than 20 lacs records in 2 months only.

[smrazaabidi]

Very great, Sir, Could you please tell me how this 1.7 million excel file be used in machine learning model as a base file? Further more I am exporting data from Impala (Cloudera) so how should I upload big data in excel from Impala. Many thanks,

[aravindbgb]

dear sir, I can't find the query and connections in new sheet by clicking queries and connections it's not visible.

[LearnLead]

Thanks you so much sir for sharing valuable knowledge with us. Here I am facing add in issue of power pivot. I am using excel 2016 home version can you plz guide me how to add power pivot 2016 home version? Thanks in advance from Lahore - 🇵🇰

[Cosmicsciences]

Hi sir also how we can import excel power query data to power bi

[praveenkumari]

Data filter me 10000 limit lagi hai please solve this problem bhai

[rahulmangal]

Sir, ye video bahut helpful raha, par kya 15 lac row data ko alag - alag 2 excel sheet me complete download kiya ja sakta hai kya

[minaK]

App apni TXT file share karege please, so I can practice on it?

[minaK]

Very hard to practice, I am not sure who to work on the file you have provided