Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
STIBBS_807
Resolver I
Resolver I

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?  

 

Any suggestion will be useful.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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])

 

amitchandak_0-1683323670642.png

 

remove all other columns

amitchandak_1-1683323750496.png

 

 

Exapnd

amitchandak_2-1683323768807.png

 

 

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

View solution in original post

2 REPLIES 2
STIBBS_807
Resolver I
Resolver I

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
Super User
Super User

@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])

 

amitchandak_0-1683323670642.png

 

remove all other columns

amitchandak_1-1683323750496.png

 

 

Exapnd

amitchandak_2-1683323768807.png

 

 

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.