HewBR's avatar
HewBR
Icon for Advocate II rankAdvocate II
2 years ago
Status:
Done

Copy Function Not Working in DAX Query View (may 2024 and QF1)

In the May 2024 release(s) of Power BI (including version QF1 2.129.1229.0), there is an issue with the DAX Query View where the 'Copy' function does not work as expected. Although the 'Copy' button is available and no error message is displayed, clicking the button does not copy the results to the clipboard.

One of the key features of the DAX Query View is the ability to export intermediate query results, refine or filter them in Excel, and further improve them using DAX. This feature is especially beneficial for users transitioning from Excel to Power BI. Perfect, MS! However, the inability to copy and paste query results significantly reduces the functionality of this tool.

Steps to Reproduce the Bug:

  1. Create a query in DAX Query View.
  2. Click the 'Copy' button.
  3. Attempt to paste the results in any text editor or Excel.

Expected Result: The selected query results should be copied to the clipboard and should be pasteable in any text editor or Excel.

Actual Result: Nothing is copied to the clipboard, regardless of whether cells are selected or not.

Please address this issue to restore the full functionality of the DAX Query View.

Content Packs

6 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi HewBR 

    Based on the scenario you describe, I upgraded Desktop to 2.129.1229.0 64-bit (May 2024) and tested it. Here are the results of my test, I was able to copy the query to Excl,and did not have the problem you described.

    May I ask how did you update your Desktop? Did you install it from a re-downloaded installer after uninstalling the original Desktop?

     

    Best Regards,
    Community Support Team _ Ailsa Tao

  • TM_Visual's avatar
    TM_Visual
    Icon for Advocate III rankAdvocate III
    2 years ago

    I have the same issue as HewBR (btw, good job on a very comprehensive bug report).

    I am on the version  v-yetao1-msft suggests, 2.129.1229.0 64-bit (May 2024).

    My copy function works with a simple EVALUATE query for a whole table, or a CALCULATETABLE. It works with a TOPN  within that. It stops working when I introduce the SUMMARIZE function. 

     

    When SUMMARIZE is used, I am unable to copy the results of a DAX Query View query, either by using the 'Copy' button, or by selecting multiple cells in the table. I cannot copy using ctrl-c (or right click) when selecting the whole table, columns, or rows. I am able to copy the contents of a single cell by selecting it and using ctrl-c.

     

    I do not know if this is just SUMMARIZE, or if it applies to some other functions as well.

  • abhishekrws01's avatar
    abhishekrws01
    Icon for Helper I rankHelper I
    2 years ago

    Thank you for highlighting this. I also have a similar issue post-May release.

    Any workaround would be very helpful.

     

    Thanks

     

  • HewBR's avatar
    HewBR
    Icon for Advocate II rankAdvocate II
    2 years ago

    Good news. It is fixed in the PBI desktop june24 version.
    I tested with standard 'show top 100 rows' query, but also some queries that included SUMMARIZECOLUMNS, FILTER, SUMMARIZE... and all worked.
    As a bonus, we got the possibility of copy selected cells. 


    Thank you PBI team. 

     

  • TM_Visual's avatar
    TM_Visual
    Icon for Advocate III rankAdvocate III
    2 years ago

    Great! Thanks to the PBI devs and to HewBR for originally flagging.

Completed Ideas