Working with very LARGE Datasets | 4+ Million Rows | Power Query and Power Pivot | Big Data in Excel

[@swaminaths9449]

At 0:16 Hi, thanks for this. Normally in a traditional pivot if we click total column, it will typically open another sheet containing the break-up of that total column. How this will work with power query and data model?

[@akshatabhat6810]

Thanks for the video. I have a question, does it work if a sheet has multiple tabs with more than 1 million rows or should I split data in between different files with one tab

[@peterchristopherson9694]

At 11:35, you select "Only Create Connection". I'm not able to select that option, is there something that I need to do for this to be possible for me? Thank you in advance and thank you very much for uploading this content!

[@ExcelBasement]

Try again with the steps shown in the video! If the problem is still the same then email us screenshot and sample file at [e-mail]

[@johnmontojo4664]

Thank for your video, I have tried it and it work, and I am now refer to this video every time I need to consolidate

[@TheExtravaganza]

Nice explanation ! Thank you I have a question that I did the similar thing to import files into folders and then did some merging and my final table was unable to load all rows on sheet. Then I got a solution to add them in a data model which worked perfectly. But problem occurs when i added more files like it went upto 31 Million rows. Why it takes empty rows in count and does it impact in the file like more than 30 Millions rows. and I need to add like 100 of sheets more in the folder in coming days. It takes all my disk space and then gives me error. how can I fix this problem permenantly like it takes the rows only which have data and show me less rows are loaded to avoid any extra data usage. If you didn't understand my concern. I will explain it again, please let me know.

[@sandeepbondre6808]

What if there is only one table that gets populated or appended with 4million rows will Power Pivots & query still work

[@MrJaschan]

If we keep on adding the raw data in the power query data source folder every month but want to keep data only the fresh one not the duplicate as compared to previous months, how to resolve this

[@arshadalam9428]

Where do I get big data for practice

[@ExcelBasement]

data.world/datasets/big-data

[@umamahesh-x7p]

Why the M language code is not working for me ? it just don't give any suggestions when I want to create custom column.

[@hasinarafenoarisoa3747]

how to go to the powerpivot if data in powerquery is in only connexion, please!

[@Mega_world02]

While I am connecting sharepoint excel file to power bi, unable to transform as it is giving error as the data in the preview has been truncated due to size limits. What can i do to link pls help

[@chetnajha.910]

Why I am not getting table option under kind coloumn.. please reply I am stuck there

[@Yash-1567-d4g]

How to convery this data model in CSV or this combined data into CSV

[@xhielajade]

any idea how to fix this error, it says 1,357,599 rows loaded 815,889 error. I am trying to add connection to be use in Data Model. Thanks

[@ExcelBasement]

Might be its due to the technical issue related to your Dataset Column Types and Files