Forum Discussion
chayanupadhyay
Helper III
Helper IIIMultiple 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...
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.