Power Automate – save the Power BI visualization into a Excel file
This tutorial shows saving of Power BI visual content into a xlsx file, using Power Automate.
Let´s say you have visual like this:
Get values from visual
You don´t have to write the DAX code - just generate it automatically in Desktop, using Performance analyzer.
Get columns from table
The Parse JSON gets specific information from table, so as you can work with them easy. Here you can read how to do it in a minute.
Clear table
Before adding new rows into a table, let´s delete the previous content. Office Script can be very handful.
- function main(workbook: ExcelScript.Workbook) {
let table = workbook.getTable("Table1");
let rowCount = table.getRowCount();
table.deleteRowsAt(0, rowCount);
}
The script is triggered from Power Automate.
Rows into table
The table can be filled, row by row, by Power BI action (or by Office Script, for example...).
Which puts the content of visual into a table: