when export the data to excel, is it possible certain columns contain the logic of formula in excel?

[shamili · Accepted solution]

hi @Anonymous 

Yes, you can export data to Excel with certain columns containing formulas. The best way to achieve this depends on the tool you're using for the export process:

• For automation: Use a programming language (e.g., Python with openpyxl or xlsxwriter) or Excel VBA to embed formulas directly.
• For exporting from databases: Use an Excel template or add formulas after the export.
• For non-CSV formats: Save the file as an .xlsx to preserve Excel formulas.
  If you find this information helpful please mark it as a solution, it will help more users with the same problem, thank you in advance!

[Anonymous · Accepted solution]

Hi @Anonymous ,

Visual calculation results are included in all exports, except when exporting underlying data. Fields that are hidden on the visual are never included, except when exporting underlying data.

Export data from a Power BI visualization - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[shamili · Accepted solution]

hi @Anonymous 

Yes, you can export data to Excel with certain columns containing formulas. The best way to achieve this depends on the tool you're using for the export process:

• For automation: Use a programming language (e.g., Python with openpyxl or xlsxwriter) or Excel VBA to embed formulas directly.
• For exporting from databases: Use an Excel template or add formulas after the export.
• For non-CSV formats: Save the file as an .xlsx to preserve Excel formulas.
  If you find this information helpful please mark it as a solution, it will help more users with the same problem, thank you in advance!

[shamili]

Hi @Anonymous 

Yes, you can export data to Excel with certain columns containing formulas. The best way to achieve this depends on the tool you're using for the export process.

For automation: Use a programming language (e.g., Python with openpyxl or xlsxwriter) or Excel VBA to embed formulas directly.

For exporting from databases: Use an Excel template or add formulas after the export.

For non-CSV formats: Save the file as an .xlsx to preserve Excel formulas.

If you find this information helpful please mark it as a solution, it will help more users with the same problem, thank you in advance