Export data to excel

[evelyn0111]

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]

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

[v-denglli-msft]

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.

[v-denglli-msft]

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.

[MFelix]

Hi @evelyn0111 ,

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

[ToddChitt]

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.