Forum Discussion

captainlaw's avatar
captainlaw
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

captainlaw

 

To edit cell data in your dataset, the best practice is editing your source data and refresh data source. But you can also achieve it with Power Query or DAX formula. You need to select that specify column, then apply filter to find the row and replace the value in that cell. Please refer to a slimilar thread: Replacing just 1 value in a table.

 

Regards,

captainlaw's avatar
captainlaw
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Thanks Simon.  Having bunch of IF clause or using selectcolumns function will be too clunky to maintenance over time.  Maybe in the future, PBI will allow cell data modification right within the UI, like Excel.  Just a thought.  Thanks.

    • captainlaw's avatar
      captainlaw
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Just did... thanks.