Uploading to Data Model

[matratus34]

Hi - Power Pivot/Query/BI newbie here so sorry if this is obvious!

I've got 3 Excel worksheets with identical headers - each worksheet has 1.3M rows.

I'm trying to figure out how to append these to the data model as 1 table of 3.9M rows.

Any help is greatly appreciated.

 

[sandy666]

Append in Power Query then load to Data Model (if it's really necessary)

 

[matratus34]

So thats Data --> Get and Transform --> From Tabel/Range
and then append them afterwards?

Thanks

 

[sandy666]

Exactly,
You need to add all three tables from worksheets
then Append all three tables

Close&Load To...
and then load to Data Model

 

[matratus34]

That's great - thanks - much appreciated

 

[sandy666]

You are welcome
You will stay with Power Query or Data Model because worksheet is limited with rows to 1048576 only