Background
You are a large multinational grocery retailer operating across 10 countries. As the business has grown, so has the complexity of its cashflow reporting. Each country's cashflow data is stored in separate files, updated manually, and reported in isolation — leaving the finance team spending hours each week hunting down the right files, copying data, and rebuilding the same reports over and over again.
You would like to put an end to this inefficiency by storing all cashflow files on SharePoint, and connecting SharePoint file repository directly to Power BI. Your team will build a dynamic reporting solution that automatically retrieves the correct cashflow forecast for any country and week combination — eliminating manual effort and giving finance leaders instant visibility into actuals vs. forecast variance across the business.