Forum Discussion
Solved
Table with no rows causes dataflow refresh to fail
In PBi Service, I have a dataflow where one of the tables has no rows. I reference to a data table and then 'Keep duplicate rows', and this returns no rows, which is the answer I want. I want to ...
Hi CAUK
Please try adding a Dummy Row to your table when it would otherwise be empty. You can do this by modifying your query in Power Query:
1. After your “Keep duplicate rows” step, add a new step using the following M code:= Table.FirstN(#"Previous Step", each true, 1)
Then add another step to append a dummy row:
= Table.InsertRows(#"Previous Step", 0, {[Column1 = null, Column2 = null, ...]})
This will ensure there’s always at least one row in your table, even if it’s just nulls
Please give kudos and accept solution if this is helpful
Thank you!