Forum Discussion
Helper IVNew 'Enter Data' feature -- can we edit after creating table?
cwayne758 Yes, you can edit the data at any time.
Edit queries - select the table - in the Applied Steps section click on the Gear next to "Source" and it will pop up your manually built table and you can modify/add/remove values and save.
cwayne758 Yes, you can edit the data at any time.
Edit queries - select the table - in the Applied Steps section click on the Gear next to "Source" and it will pop up your manually built table and you can modify/add/remove values and save.
cwayne758Ah! silly me.
Thank you very much!
- Greg_Deckler
Community Champion
For some reason, my Power BI Desktop was not popping up the update message. Did it manually, very nifty new feature!
- DavidMoss
Advocate V
Just the answer I was looking for to modify a "Enter Data" table that needed editing. Thanks.
Anonymous sir could you please tell me how do i enter measure values in "Enter Data" table say suppose i have three
columns to enter data , Employee, cost and rate .I did enter data but when i enter cost and rate these are not shown up as measures and i cannot calculate or create any calculated measure on cost and rate columns , no sigma symbol is showing up for the cost and rate after a load.
can you please explain why?
Also if you could explain any feature that the values entered in "Enter data" such as cost and rate are not visible after refresh, we want data to be confidential and only enter once for calculations and should not be seen after refreshing report the values should disappear.
Thanks
Suresh Ramadurgam
columns to enter data , Employee, cost and rate .I did enter data but when i enter cost and rate these are not shown up as measures and i cannot calculate or create any calculated measure on cost and rate columns , no sigma symbol is showing up for the cost and rate after a load.
can you please explain why?
There are several layers to the Desktop. When you enter data, you can't build any calculations into the table itself. You need to load the data and it acts as your data source. In Edit Queries, this is "Power Query" and you could transform or add calculations in the M language. Once you Close & Apply the data is loaded into the model. This is a "Tabular Model", this is where you could create a measure using the DAX language.
Also if you could explain any feature that the values entered in "Enter data" such as cost and rate are not visible after refresh, we want data to be confidential and only enter once for calculations and should not be seen after refreshing report the values should disappear.
If I understand this correctly, you could create your measures and reference the this "other" table with the measure and hide the table from end users. Then they wouldn't be able to see the actual data other than what was shown via the measures.
columns to enter data , Employee, cost and rate .I did enter data but when i enter cost and rate these are not shown up as measures and i cannot calculate or create any calculated measure on cost and rate columns , no sigma symbol is showing up for the cost and rate after a load.
can you please explain why?
There are several layers to the Desktop. When you enter data, you can't build any calculations into the table itself. You need to load the data and it acts as your data source. In Edit Queries, this is "Power Query" and you could transform or add calculations in the M language. Once you Close & Apply the data is loaded into the model. This is a "Tabular Model", this is where you could create a measure using the DAX language.
Anonymous many thanks
This above query , i got the root cause from one your posts which says if the table is created through 'Enter data' featrure and after loading in to data model & if there is a relation with another existing table like 'Many to One' or 'One to Many' , then the fields do not show sigma sysmbol. Cost and Rate columns in my case does not show Sigma symbol. Can you explain me how could i create measures on top of those two column values Cost n Rate.
Also if you could explain any feature that the values entered in "Enter data" such as cost and rate are not visible after refresh, we want data to be confidential and only enter once for calculations and should not be seen after refreshing report the values should disappear.
If I understand this correctly, you could create your measures and reference the this "other" table with the measure and hide the table from end users. Then they wouldn't be able to see the actual data other than what was shown via the measures.
Anonymous Yes you have got me right , does Power BI has a featrue of parameter on cost and rate to be inputte dater refresh of report and all other measures and reference the cost and rate input what user has entred . its like input selections for report to run in our case input value of employee and report returns all measures based on that value.
