Update the Online Dataset with out having to save and publish the Desktop Power BI
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?