Refresh all other tables except the one that returns an error

[Maria_Maria]

Hi!

Usually Power BI aborts refresh of all the tables if one of them returns an error.

Like that:

When this happens, is it possible to make PBI refresh all the tables that don't return an error? Basically what I need it is to get past the 'blocked by failuers in other queries' thing.

Alternatively, is there a way to keep the cache data for the tables that return errors and refresh the tables that don't?

Thank you!

[penguin-96]

Hi Did you get a solution to this?

What essentially you want is to do a try except handling like the way we do in python.

I am looking for something like this as well. Please let me know if you found a solution.

@Maria_Maria 

[Saap]

Hi @Maria_Maria 

You can try to disable these options:

[Maria_Maria]

Basically what I need it is to get past the 'blocked by failuers in other queries' thing

[v-shex-msft · Accepted solution]

HI @Maria_Maria,

After I check the option of power bi desktop, I haven't found any related option to skip the processing on the query with the issue. These data loading and transform operations will be canceled when the issue appeared.

For this scenario, I'd like to suggest you submit an idea for this requirement.

Microsoft Power BI ideas

Regards,

Xiaoxin Sheng

[Maria_Maria]

Thanks @Saap 

Thank you for the option. I think I was not clear about what I want. I have a report with around 20 tables. Sometimes some on them (every time a different one) returns an error. I know the resason and ,say, it's a planned error. What I need is a way for all other tables still refresh in the published report. I set up several refreshes, so the table that had returned an error in the previous resresh, was able to refresh during the nest time.

[amitchandak]

@Maria_Maria , One of the tables is failing, Scroll up and check, Fix issues like missing columns or data type change, if it shows that

If you are not able to get the issue, then refresh the table one by one, option right click and check

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s


refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

[Maria_Maria]

@amitchandak hi!

Thank you, but this is not what I am asking. I know why the table fails. My question was if it's possible for all other standalone tables to refresh except the one that fails.

I need a workaround when the published report got all the data from tables that don't return an error, so refreshing one-by-one is not an option here either