cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Julian_S Frequent Visitor
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 Team
Community Support Team

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.

 

4 REPLIES 4
Super User
Super User

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".

Near SE WI? Join our PUG Milwaukee Brew City PUG
Julian_S Frequent Visitor
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 Team
Community Support Team

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.

 

Julian_S Frequent Visitor
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
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 432 members 4,317 guests
Please welcome our newest community members: