Unisoft Technologies · Dashboard Dhamaka Ep 01 · Practice folder (comment FOLDER)

1 - Branch Sales: 11 branch files, same format (sheet Sales). Connect this folder in Power BI Desktop:
    Get data > File > Folder > Connect > path > OK > Combine > Combine & Transform Data > Sales > OK > Close & Apply
    Expected: 330 rows, Wardha total 6,20,000.
2 - Next month: copy these 11 files into 1 - Branch Sales, then Home > Refresh. Expected: 660 rows.
3 - Twist test: Canteen_Visu.xlsx has the same columns, so it gets combined too (663 rows). Keep only report files in the folder.

Steps on one page: 'Steps - Get data from Folder.pdf'.
Power BI course (PL-300 aligned), Dharampeth, Nagpur + live online: unisoftindia.org
