cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Maria_Maria
Helper II
Helper II

Refresh all other tables except the one that returns an error

Hi!

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

Like that:

Maria_Maria_0-1657191296384.png

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!

1 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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

6 REPLIES 6
Saap
Resolver II
Resolver II

Hi @Maria_Maria 

You can try to disable these options:

Saap_0-1657268437481.png

 

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

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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
Super User
Super User

@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



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s || 50+Power Query List Functions : Learn Power Query List
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

@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  

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Top Solution Authors