Forum Discussion
Multiple sheet load in Power BI
Hi
Have you done all of the transformation inside the Powerquery editor? If so, then the process is already 'automated'.
Once you refresh the data source of your PowerBI report, it will automatically repeat all of the steps you've done in the Powerquery editor. So you simply need to schedule the refresh of your report on the PowerBI Service.
Let me know if this helps.
Anonymous Thank you for your reply, yes i have done all the transformation within Edit query window (Power Query) but i have done it for one sheet, i can't combine all the sheet because once i combine i am unable to convert the data in tabular format as shown earlier:
after combining the sheet1 and sheet2 the data looks in below format:
so if i delete top 7 rows and transpose the data then i will have multiple columns with Country Name and Period , PFB the snapshot for your reference: (Column2 & column13 for country names and column3 and column14 for period) and also there is lot of extra columns which i removed since i can see the data at this moment but in case of automation even if there is one extra row with some text it might impact the transformation so i will make sure the source file format remains same.
Apologies, the description became too big, i hope the problem statement is making sense. Please let me know if you need more information.
Thank you for your help and time.