Dataset Refresh from Excel File without the manual work?

Question

Help for a Newb...&nbsp;I have an excel file which I uploaded into Power BI. &nbsp;After some modest gymnastics with the data (parsing a date field to make a date from text, adding a calcuated column to create an alias, renaming columns and deleting those that are unimportant)...&nbsp;Voila, &nbsp;I have the&nbsp;experience I want to make "consumer facing". &nbsp;&nbsp;But what about tomorrow?&nbsp;&nbsp;Since I can't automate the file, I need to replace it with the "more current" flat file.&nbsp;I am looking for some instruction how to replace the original dataset (with the new one) without having to recreate all the manipulation I had to do to achieve my desired result.&nbsp;Please advise how to upload the "new dataset" without going through all the steps I had to to develop the desired experience?&nbsp;Thanks!

phil_seamark · Answer

You can install a personal gateway on a machine that is always on. This can be configured to point to your local file and told to refresh several times a day if need.

Have a read here.

https://powerbi.microsoft.com/en-us/documentation/powerbi-personal-gateway/

An alternative might be to store your Excel file up in a One Drive

anonymous · Answer

Thanks Phil, this is great. &nbsp;Heading in this direction for sure.&nbsp;But in the meantime, I am looking for some low tech instruction to satisfy a more immediate need.&nbsp;Literally, I am asking how to upload the new dataset (with a new flat file), and replace the old one. &nbsp;And, if all my work (described above) will continue when the replacement dataset is uploaded. &nbsp;A summary of steps to follow would be greatly appreciated.&nbsp;Thanks!

blopez11 · Answer

If you used power bi desktop to load, shape and transform your file in the query editor, then you can just replace the older file with the new file, and perform a refresh in power bi desktop, then publish to the power bi service

anonymous · Answer

Thanks&nbsp;blopez11&nbsp;and I hate to make this more painful than it needs to be...&nbsp;Am I simply launching Power BI desktop and clicking Get Data and uploading the replacement dataset? &nbsp;Any step-by-step you would provide would be greatly appreciated.&nbsp;Also, there is an "IF" statement that was created using the New COlumn function in the modeling tab, will this persist with the upload?&nbsp;Thanks!&nbsp;&nbsp;

vvelarde · Answer

Anonymous&nbsp;Hi, If you have a different file:&nbsp;Sample:&nbsp;Your file now is "WORKINGSHEET1.XLSX. And tomorrow you want to replace this with "WORKINGSHEET2.XLSX" without losing all the transform and manipulation in the data.&nbsp;To do it this you have several ways:&nbsp;1. Mantain an unique name of the XLSX File and everyday replace it with new data. (Always be WORKINGSHEET1.XLSX". Just Click on REFRESH and the data will be loading to Power BI DESKTOP.&nbsp;2. &nbsp;Change the source of the data.&nbsp;&nbsp;Step 1. Go to&nbsp;Data Source Settings&nbsp;&nbsp;Step 2. Change the source of the file&nbsp;&nbsp;Ok. &nbsp;And is ready. If you want made a refresh action.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Dataset Refresh from Excel File without the manual work?

8 Replies

Related content

Refresh dataset api

dataset refresh

Refreshing dataset

Dataset refresh error - timeout

Refresh Power BI Dataset using Power Automate