Update the Online Dataset with out having to save and publish the Desktop Power BI

[STIBBS_807]

I have a set of reports that are Excel spreadsheets with multiple tabs.  Once a month, I have to run the data,  transform it, refresh the Power BI reports, and republish Power BI.  I am not changing the Power BI report's structure; I am simply restoring the data to be reviewed on my Sharepoint Site.  I want to load/refresh the data set only.  Can this be done?

I have tried to load my Excel spreadsheet by importing them into Power BI online in the data set area, and the import will only load one tab of the spreadsheet.  How do I get a multiple-tab Excel Spreadsheet to load each tab in a dataset without having to open Desktop Power BI, refresh, and republish the whole thing again?  Do I need to separate each tab into a separate Excel WorkBook?  

Any suggestion will be useful.

[STIBBS_807]

Thank you for the suggestion.  However, the tables do not have the same data fields so the data would become massive.  I guess the solution is to save each sheet separately.

[amitchandak · Accepted solution]

@STIBBS_807 , I hope you want to combine all Excel sheets into one table. (In case Sharepoint flow might change a little bit)

Add the Excel sheet, remove all steps other than the first step 

Add a new column

= Table.PromoteHeaders([Data])

remove all other columns

Exapnd

You should be able to configure refresh for this on power bi service