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

Adding a row manually to manually created table

Dear all

 

I seem to struggle adding a new row to a table i've created via "Enter Data" under "New Query" section on the "Query Editor" form. Only time i was able to add new rows (along with columns and values) when while on the "Create Table" form - but once clicked OK i see no option to add additional row. I can add new columns but not rows, and since this was created manually and there is no outside source i find it frustrating! Can you advise if this is by design or is it just me not comprehending it fully?

1 ACCEPTED SOLUTION

Accepted Solutions
jahida Established Member
Established Member

Re: Adding a row manually to manually created table

To add rows to a manually entered table, click on the gear beside the step named Source:

Capture.PNG

That should open up the menu you're looking for. Not very intuitive but gets the job done.

View solution in original post

8 REPLIES 8
jahida Established Member
Established Member

Re: Adding a row manually to manually created table

To add rows to a manually entered table, click on the gear beside the step named Source:

Capture.PNG

That should open up the menu you're looking for. Not very intuitive but gets the job done.

View solution in original post

Ansicone Frequent Visitor
Frequent Visitor

Re: Adding a row manually to manually created table

Wow, not very intuitive at all - i was expecting something like right click on the table - edit table or something, but as you pointed it out it now actually makes sense to be there too... Anyway, thank you!

efglynn Regular Visitor
Regular Visitor

Re: Adding a row manually to manually created table

The user interface is quite bad here.  When opening/re-opening a manually entered dataset, one should immediately see an Excel-like interface.  I shouldn't have to Google to find out how to add a new row to a manually created PowerBI dataset.  The "Solution" here should be tagged a "Workaround" until this is fixed correctly.

qa4432 Frequent Visitor
Frequent Visitor

Re: Adding a row manually to manually created table

I agree!  For all the capabilities in PBI, it should be very intuitive to add additional rows to an already existing table either source from a database or manually created.

arelf27 Regular Visitor
Regular Visitor

Re: Adding a row manually to manually created table

LOL. Googling too since for the life of me I couldn't figure out how to do this... Now I'll know. Thanks for having this thread!

GregHart New Member
New Member

Re: Adding a row manually to manually created table

WOW! He's right, ... not very intuitive. When developing any interface, when confronted with confusing the users or adding one more item to a right-click menu, I would opt for the extra menu item all day long.

aktec4 Frequent Visitor
Frequent Visitor

Re: Adding a row manually to manually created table

Thank you! this is what I m looking for my solution. 

wulingmountain Frequent Visitor
Frequent Visitor

Re: Adding a row manually to manually created table

Brilliant, thanks

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and 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.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 56 members 1,199 guests
Please welcome our newest community members: