A client asked us to analyze a 30-person daily schedule sheet in Power BI. The sheet turned out to be a wide, Excel-style layout far from BI-ready. Here's how we normalized it with Google Apps Script and connected it to Power BI, including the pitfalls we hit along the way.