Forum Discussion
data refresh to work, if other excel data source fails to refresh or is broken
Hi, If the PBI report is based on multiple data source then what could be the method for schedule refresh to work on the web service if other excel data source is broken or fail to refresh? Appr...
Greg_Deckler
Community Champion
Community ChampionDeoYadav Depends, you can refer to this: Dealing with errors - Power Query | Microsoft Learn. You could, for example, add a step or multiple steps that removes all errors in all columns. Thus, if there was an error involving data then this would not impact the loading of the table (it would likely load as a blank table for example) but not result in an error that would affect the other queries potentially. However, it is doubtful that the report would end up with valid information anyway.
Greg_Deckler thank you for sharing, will go through it and try if it works for me. in my case, I'm using excel data on the cloud and other data sources too.
thank you.