Forum Discussion
Refresh all other tables except the one that returns an error
- Anonymous4 years ago
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
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