Now, suppose during your process of automating the reporting in Google Sheets, your script encounters unexpected data format changes and fails midway. How would you troubleshoot and resolve this issue, considering your experience with VBA and Power BI?