Forum Discussion
Power BI export to excel using Power Automate inserts blank row
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.
It's a bit of a crossover topic, but you may get a quicker answer, especially to your last question, on the PowerAutomate forum.
https://community.powerplatform.com/forums/thread/?partialUrl=MPACommunity
Thanks, KNP. I'll try to figure it out and if I can't, I'll ask a question on the Power Automate forum. I would like to accept Mohamed's reply as the solution, as he first correctly identified the reason for my initial problem. My bad for making it into a run-on question.
Alan.