"Refresh all" fails cuz 1 table is temp unavailable. Way to have Power Bi skip over failures?

[mmace1]

Hi,

I have a report that loads 23 tables.

One of those tables sometimes fails to compile on our server.  When that happens, "refresh all" will fail, and nothing will refresh.

I can go in and manually refresh the other 22 tables, but that's a bit of a pain.

Is there a way to make Power BI, when it can't refresh 1 table, just skip over it and continue refreshing the rest?

[v-jiascu-msft · Accepted solution]

@mmace1

Hi,

It seems that it can't pass the failure table dynamically. But there is a workaround. We can change a property of the failure table to exclude it from “Refresh All”. Have a look in the picture. Hope this would help. You also can support or vote an idea to make this better in here:https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15575454-extend-include-in-report...

1. In Query Editor;
2. Right click the failure table.
3. Uncheck “Include in report refresh”.

Best Regards!

Dale

[mmace1]

That's a great way to deal with it - thanks!

[v-jiascu-msft]

It's my pleasure!

Best Regards!

Dale