cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: New 'Enter Data' feature -- can we edit after creating table?

@SureshR I don't know which post you are referring to, but if all the values are numeric, the sigma should show up. If the value is decimal, you can transform the datatype in "Edit Queries" and it will show the symbol.

 

Sticky answer to your second question. Yes, you can use parameters, but only in the Desktop and probably not in the way you describe. This video shows how Patrick Leblanc made this work off an Excel file, maybe you can see if there is a solution to your scenario.


Near SE WI? Join our PUG Milwaukee Brew City PUG
karaoan
Advisor

Re: New 'Enter Data' feature -- can we edit after creating table?

It depends on your requirements. Edit table will only work in Power BI Desktop. If you need it to work on the end user side for just the collection of a few numbers then the PowerApps integration might help you. If you are looking for serious planning functionality, you might want to have a look at: www.acterys.com This solution offers sophisticated write back and planning for Power BI and Excel. In addition to writing to a relational table the solution offers a powerful OLAP in-memory engine on top of SQL Server that caters for large scale multi user write back requirements that typically don't work with sufficient performance if you just write to a relational table.

 

Martin

Highlighted
PaulDBrown Senior Member
Senior Member

Re: New 'Enter Data' feature -- can we edit after creating table?

Wouldn’t it be nice if we could improve the user experience (ie. for those business users who haven’t a clue about PBI, “edit queries” or indeed sources within) to include a functionality whereby by the click of a button the input table would show up so they can edit away and then close and apply? This would make Power Bi much more powerful for “what if” scenario analyisis, rebates and discount finacial impact etc IMHO....

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 248 members 2,643 guests
Please welcome our newest community members: