Anonymous's avatar
Anonymous
Not applicable
6 years ago

Abort table refresh if table is empty

Sometimes you are unlucky and the table you are refreshing is empty in the database. In that case, often you don't want the refresh of the table to go through, but instead, have the refresh fail wh...
Other
Maria_Maria's avatar
Maria_Maria
Icon for Helper II rankHelper II
4 years ago

This is great! What if I have several tables and I need to abort refresh only for thoses that are empty? If I use '...then error', PBI aborts refreshes for all the tables. I can't figure out how to re-write the query so only the empty tables' refreshes were aborted.