Forum Discussion
Power Automate export to Excel
I have a Power BI Matrix visual setup to present a data table. This will show all the information available however might not show any information in a given cell if there is nothing to show. Whe...
You should probably ask this in the Power Automate forum as someone might be able to help you with the advanced settings to include rows with blanks.
In Power BI though, if you wrapped your measure with COALESCE() it would return a zero, and then export. So whatever your measure is, use this:
COALESCE(
<your entire measure>,
0
)If your measure returns any value, this will keep that value, but if it returns blank, this will convert it to zero. That will make Power Automate work, but may not be visually appealing on the visual in Power BI itself.
You could have two visuals. One that looks like you want with the blank, then a hidden visual that has the COALESCE in it, and that could be the one Power Automate exports when the button is clicked.