Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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!
Solved! Go to 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.
Regards,
Xiaoxin Sheng
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.
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.
Regards,
Xiaoxin Sheng
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.
@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
@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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
89 | |
86 | |
82 | |
64 | |
49 |
User | Count |
---|---|
124 | |
110 | |
88 | |
68 | |
66 |