Forum Discussion
Power bi Table view Formula bar greyed out , its only enable when i add new column pls assist.
- 2 years ago
Hi Srehman
This isn't a bug. The bar remains grey until you add a new measure or calculated column, or until you select the measure/calculated column. In all other cases, there's nothing to show, so the bar stays grey.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- 2 years ago
Yes,It could be true. I encountered this problem when attempting to copy a table from the table view. Although it allows me to copy, when I paste it into Excel, no data is pasted. In my previous Power BI version, I could easily copy and paste tables from the table view by right-clicking. Could you please assist with this?
- 2 years ago
Srehman
Yep, this is a bug, that has already been reported :
https://community.fabric.microsoft.com/t5/Issues/March-2024-Breaks-Copy-Table/idi-p/3792111The teem is on it.
Until the issue is solved you can copy the table from PQ.
I tested it on my machine and it's working ok.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- Anonymous2 years ago
Hi all,
First of all, many thanks to Ritaf1983 for your very quick and effective replies.
This copy table feature in Power BI Desktop has been confirmed as a known issue internally. Please be patient to wait for fixing. If there is any news, I will update it here.
There is a different workaround that you could try to use:
Try to use DAX Query View:
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi all,
First of all, many thanks to Ritaf1983 for your very quick and effective replies.
This copy table feature in Power BI Desktop has been confirmed as a known issue internally. Please be patient to wait for fixing. If there is any news, I will update it here.
There is a different workaround that you could try to use:
Try to use DAX Query View:
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
in my table rows are more than 48000,find out the way if we more than 29411 rows limitation issue , can breakdown by records in Asc and Desc orders , i tried and able to copy and paste full table by using 2 queries. finally got it . its works
EVALUATE
TOPN(
29000,
'LocMasterPQ',LocMasterPQ[CycleCountFrequency],
ASC
)
EVALUATE
TOPN(
18169,
'LocMasterPQ',LocMasterPQ[CycleCountFrequency],
DESC
)
- Anonymous2 years agoNot applicable
Hi Srehman ,
Please download the latest version of Power BI Desktop, the "Copy table" feature works well.
Official download link: Download Power BI Desktop from Official Microsoft Download Center
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.