Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Data export to excel using macros

I am just wondering if I can export visuals data out to excel using macros. If anyone is using such macro can share the code. I know it can be done through just by clicking the export data. But I want a macro for that as I need this data to be extracted to different excel templates.
  • Anonymous

     

    As MattAllington said, marco is not supported in Power BI Desktop. Since you can export the visual data into .csv file, you can use that file as data source in Excel. It can be used by different excel templates as well.

     

    Regards,

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee

    Anonymous

     

    As MattAllington said, marco is not supported in Power BI Desktop. Since you can export the visual data into .csv file, you can use that file as data source in Excel. It can be used by different excel templates as well.

     

    Regards,