cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mmace1 Member
Member

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

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?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: "Refresh all" fails cuz 1 table is temp unavailable. Way to have Power Bi skip over f

@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”.

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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

 

 

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Community Support Team
Community Support Team

Re: "Refresh all" fails cuz 1 table is temp unavailable. Way to have Power Bi skip over f

@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”.

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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

 

 

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mmace1 Member
Member

Re: "Refresh all" fails cuz 1 table is temp unavailable. Way to have Power Bi skip over f

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

Community Support Team
Community Support Team

Re: "Refresh all" fails cuz 1 table is temp unavailable. Way to have Power Bi skip over f

It's my pleasure!

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.