How do you copy a cell value in Data view

[MorePowerBI]

Hello,

PBI desktop has three different "views"  that can be selected from the left - Report, Data, and Model.

In the Report view, I'm able to create a table or matrix visualization and copy individual cell values.

When I view the table in the Data view there are two "copy" options when you right-click a cell - Copy and Copy table.

When I click Copy I end up copying the entire column and Copy table copies the entire table. 

Is it intentional to not have the ability to copy single cells in the Data view?

[v-yalanwu-msft · Accepted solution]

Hi, @MorePowerBI ;

Another way is tranform data then in power query .

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@MorePowerBI yes this is how it works, not to copy the cell but the entire column or entire table. To copy a value for a cell, you need to first filter and then use the copy function.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[ashamsuzzoha]

@parry2k, how do you filter to a specific value on the drop down menu if you can't copy and paste the value from the table?

[aaronv]

for sure!  This is absolutely needed for data cleansing and other reasons!