Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
captainlaw
Employee
Employee

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 source file and refresh.

Thank you!

6 REPLIES 6
Anonymous
Not applicable

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.

@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,

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

 

You can vote this idea.

 

Regards,

Just did... thanks.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors