Forum Discussion
Solved
Power BI export to excel using Power Automate inserts blank row
Hello, I'm very new to all of this, and this is my first attempt to use power automate from power bi. I have a power bi report and would like to export the data to an excel file using power automate...
Hi AEnns
Considering the cases why this issue may have occured, just make sure of these few points:- Verify whether the Excel file template used has a blank row
- Consider replacing blank values in Power BI measures with zeros using COALESCE to ensure consistent export.
- If these don't work, use a filter in the flow to exclude empty rows before inserting data into Excel.
I think using a filter in the flow to exclude empty rows would be the way to go. Can you give me a little guidance on that? Where would I insert that into my flow. Currently I have the following steps:
On Power BI button clicked
Get file content (gets the template file)
Create file (creates the output file)
Apply to each --> Add a row into a table (Excel)