Forum Discussion

evelyn0111's avatar
evelyn0111
Regular Visitor
1 year ago

Export data to excel

I'm trying to export data to Power BI.
However, the Export Data button is not active.
Please let me know what I need to do to activate that button.

 

5 Replies

  • Hi evelyn0111 ,

     

    Check on the options if you have the don't allow export data selected:

     

  • Please describe the ENTIRETY of the visual you are trying to Export Data to. 

    Some things may prevent that option.

    For example: Visual Calculations (preview) disable that option.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi evelyn0111 ,

    May I ask if you have gotten this issue resolved?
    If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster .
    Thank you very much for your kind cooperation!

    Best Regards,
    Dengliang Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • evelyn0111's avatar
    evelyn0111
    Regular Visitor

    Visual Calculations (preview) disable that option.
    -> ToddChitt I'm using visual calculations to edit the date elements of the table.

    (There are no other visualization calculations.)
    * Dax code : a = DATE(YEAR([a_real]), MONTH([a_real]), DAY([a_real]))

     

    Is there a way to avoid exporting the powerbi visualization object table data?

    MFelix The method you mentioned has already been applied, but it remains the same problem

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi evelyn0111 ,

      According to Microsoft documentation. It's a limitation.
      Using visual calculations in Power BI Desktop - Power BI | Microsoft Learn
      You cannot export data from a visual that uses visual calculation.

       

      If you want to make it possible, please find the idea and vote on it or create it here.

      Microsoft Fabric Ideas
      Our product team has direct visibility of these ideas, and they will implement it on the basis of the highest number of votes received.

       

      Best Regards,
      Dengliang Li

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.