Showing results for 
Search instead for 
Did you mean: 
Responsive Resident
Responsive Resident

creating new tables


i'm on a project to study on-time performace for flights for various airlines and airports. i have appended few data and currently based on 2.5 years of data, my pbix file has grown to about 270mb in size. i still need to add & study data of 3 more past years & continuously add new data for coming months and years. the imported data is in csv format from a government bureau of statistics. 


here are my questions - 


1. what is the max file size limit with imported data that to work efficiently ?

2. through power query, i appended the data according to calendar year (jan-dec). so, there are now 2019, 2020, 2021 (upto may 2021) data in there. kindly advise on how to generate smaller files based on 

   a. operating carrier (field name: OP_CARRIER)
   b. airport (field names: ORIGIN and DEST)

the filenames are available in all the current '2019', '2020', '2021' tables in the pbix file.

tks & krgds, -nik


many thanks for your inputs, @littlemojopuppy.

i'll consider them accordingly.

krgds, -nik

View solution in original post

Super User I
Super User I

Hi @nikahafiz 


Regarding the first question: that really depends how much memory/horsepower your computer has.  Everything is held in RAM so if the computer is a weakling, the effective limit will be smaller.  It will also depend on how well your data is modeled.


And regarding modeling, I'd suggest not having tables for individual years.  I'd merge them all into a single table with Year as an attribute of that merged table.  Will make writing measures easier.  And you shouldn't have to create smaller files for carrier/origin/destination.  That will just complicate things too.


Hope this helps!  🙂

many thanks for your inputs, @littlemojopuppy.

i'll consider them accordingly.

krgds, -nik

View solution in original post

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors