Forum Discussion
Edit Data within PBI Desktop?
Hello PBI Folks, I'm wondering if desktop allows me to edit individual cells of a dataset that was loaded from Excel? If desktop does not support editing of one cell, I'll simply edit from the sour...
I think you need to edit your source data and refresh.
Editing the data in PBI would open up a minefield of data integrity and security issues. That being said, you can of course transform the data when you get, ReplaceValues etc. with the Power Query scripts, or enter data manually or via script (e.g. Chris Webb's post on Creating Tables In Power BI/Power Query M Code Using #table())
I don't think security would be an issue to edit data cause it's like you said transforming data. Yes, I'm able to write M language to modify entire column of data, just wasn't sure if there's script to edit individual cell, so I assume not. I'll go the route of modify excel and refresh.
Thanks.