Solved: Getting the model to use the latest excel spreadsh...

George_Redies · ‎10-15-2016

I have a question about updating daily data from excel to powerbi. I have 2 sheets that were used to build the model call them oct13 and oct13all. Now I want to bring in the latest days data which are on sheets Oct14 and Oct14all. These load fine in power bi but how do i ask powerbi to replace the Oct13 sheet with the latest sheet called Oct14? I am not saving them as tables, just simple spreadsheets,

Thanks George

Seth_C_Bauer · ‎10-15-2016

@George_Redies You can save these excel files as CSV's and have Power BI connect to the folder. Just move the new file in and remove the old one and refresh.

Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

Seth_C_Bauer · ‎10-15-2016

@George_Redies You can save these excel files as CSV's and have Power BI connect to the folder. Just move the new file in and remove the old one and refresh.

Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Getting the model to use the latest excel spreadsheet.

Helpful resources

Power BI September 2023 Update

Learn Live: Event Series

Exclusive opportunity for Women!

Power Platform Conference-Power BI and Fabric Sessions