Eugene Roh on 13 May 2016 04:03:29
Needs for enabling to edit data in Edit Queries.
We need to change the data directly in the Edit query menu.
When the dataset like excel files loaded in Power BI, it should be modified or input data directly by the users.
For example, select the cell in column to change the data, copy and paste.. etc
Then we don't need to start it over in excel to change the data manually.
I think if it comes true, Power BI will totally substitute for Excel in much powerful, visualizing way.
In conclusion, we need
1. Direct data change in Query Edit.
2. Exporting the files in various formats.
3. Enable to change the font color in Text Box
- Comments (2)
RE: Needs for Query data change.
If I cant do what I need to within power bi, I will just use some other software. If I am already using another software, I will just write my reports there. I am not daisy chaining BI tools.
RE: Needs for Query data change.
It would be nice if there was a way to edit data within PowerQuery.Sometimes, you have raw data in a text file that is massive. Finding that data (in a text editor) and editing it in the source would be difficult and error prone. Power Query should have a way to change data (a wizard of sorts would be nice). The way I imagine it working is that the wizard helps you select which rows to edit and then which values to change. In the background, the wizard writes M code that is suitable for the language and inserts it as a step. eg. 1) assigns a sequential id for each row, 2) assigns a hash for each row2) manually defines a new table with matching row hashes and edited data (the whole row not just changed cells). Here it would probably be best to save the data in an external file that is loaded when the query runs, to avoid having the m code littered with data.3) deletes offending rows from original4) merges new rows5) sorts by id6) removes temporary sequential id and hashes.^ this way, whenever the data is refreshed from the source, *if* the offending row still exists as it did when the edit was defined, it gets "re-edited" just as the user intended.