cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Julian_S
Frequent Visitor

Error on creating a new table: "You have reached the maximum size of the table"

I'm doing some evaluation and testing on visual styles, and as part of my investigation I wanted to create a table with some dummy location data in it, to connect to the various map visuals.

 

I created a new table using the "Enter Data" button in Power BI. There's only 500 rows and six columns. I then wanted to go back and add a seventh column with some dummy values. When I clicked on the asterisk (*) in the column headings I received the following error message:

 

Max Size.jpg

I get the same error if I try to click into the cells of a new column. I deleted about 250 rows of my data and found that I was then able to add a new column. Why am I unable to do this with just 500 rows? If I had millions of rows of data I could understand reaching a limit, but with 500? Am I missing something or is there a severe restriction on manually-created table sizes? 

 

I'd be grateful for any advice

 

Julian

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Error on creating a new table: "You have reached the maximum size of the table"

Hi Julian_S,

I find a similar post for this problem, one user test this andfind that it seems will limit to 3000 cells when enter data. You could refer to this post (last reply) for details.

And I think you could follow above suggestions to enter data in Excel and load this to powrbi to see whether it work or not

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

4 REPLIES 4
Super User III
Super User III

Re: Error on creating a new table: "You have reached the maximum size of the table"

@Julian_S I don't know what the "enter data" thresholds are, but its designed for low volume ad hoc additions to a report. Your use case sounds like you should be putting that data in some other format - Excel? then connecting to the Excel file via "Get Data".


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
Julian_S
Frequent Visitor

Re: Error on creating a new table: "You have reached the maximum size of the table"

Hi Seth

 

Thanks very much for a speedy reply. You are no doubt right, I could put this data set in Excel and import it. It started out as just about 10 rows and 3 columns, so I input it manually. Then as I worked through things in my evaluation, I wanted to add more columns, and then more rows, so it's kind of grown organically. 

 

I'll try putting it in Excel and see how that imports.

 

Thanks again

 

Julian

 

Community Support
Community Support

Re: Error on creating a new table: "You have reached the maximum size of the table"

Hi Julian_S,

I find a similar post for this problem, one user test this andfind that it seems will limit to 3000 cells when enter data. You could refer to this post (last reply) for details.

And I think you could follow above suggestions to enter data in Excel and load this to powrbi to see whether it work or not

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

Julian_S
Frequent Visitor

Re: Error on creating a new table: "You have reached the maximum size of the table"

Hi Zoe

 

Thank you for your reply, and for the link. I did try to look for existing threads on the subject but didn't find that one, so thank you. That does answer my question. Thankfully I am only creating some dummy test data so I can keep it under that limit, but for future production use I'll use an Excel workbook if I need to go over the 3000 cell limit. 

 

Regards

 

Julian

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors