Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
Solved! Go to 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
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.
@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