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.
Hi Mohamed, thank you for your reply. I believe you have answered the question. The template file does have a blank row. I'm going to go test that and get back to you.