Forum Discussion
Multiple sheet load in Power BI
Hi All, I have one workbook with multiple sheet, PFB the format of each sheet: I need to load all the sheet and convert in below format: Company NameCountry NamePeriodKPI xyz Cou...
Workaround for the solution (which i should i have thought earlier but wasn't clear that i will always get 3 sheets in workbook)
Since i only had 3 sheets in workbook, i loaded the indvidual sheet in seperate table and formatted in tabular model and then combined the three tables and created as new table which will have data from all the three sheets in expected tabular format.
Not sure how to format in tablular format if if we get multiple sheets (dynamically) in same format in workbook.
But able to solve the issue in hand :)