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.  
evelyn0111's avatar
evelyn0111
Regular Visitor
1 year ago

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
    1 year ago

    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.