Power bi Table view Formula bar greyed out , its only enable when i add new column pls assist.

[Srehman]

[Ritaf1983 · Accepted solution]

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

[Srehman · Accepted solution]

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?

[Ritaf1983 · Accepted solution]

@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/3792111

The 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

[Anonymous · Accepted solution]

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.

[Srehman]

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

    )

[Anonymous]

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.

[Srehman]

thanks , but cannot copy full table due to limitation of 29411 rows or 15 mb.

Rows limitatation only 29411

[Ritaf1983 · Accepted solution]

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

[Srehman · Accepted solution]

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?

[Srehman]

Thanks for the update.

[Ritaf1983 · Accepted solution]

@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/3792111

The 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

[Srehman]

i have no option "Copy Entire Table"  on power bi Power query, do you know how can i enable it.