Forum Discussion
Quick Refresh - Only adding the latest excel file
Thank you, that video i think will solve my issues. I have awatched it a couple of times and i think it makes sense. Hopefully i can put it in to practice.
Just referencing you alternative resolution, what is the ETL and what do you mean by connect to the dataflow instead. Although i have a year of PowerBi experience under my belt there is a lot i don't know as never needed to so i will apologide in advacne if this is basic knowledge i have missed.
Thanks again
The ETL is just the transformation you've applied to the files in the folder, say, for up to Feb this year. You can use DAX studio to extract the output of that as csv. Establish a connection to that file then append that to the query of the current files. Your current files should start getting data from files after Feb. This should be faster as power query will need to apply further transformation only to a small number of files or maybe just one file.
Or you can move the query of the historical files to Dataflow. It is the same query but filtered to just the historical data. Dataflow will refresh just once which output is stored in Azure. You can use then connect to that dataflow in desktop and combine it with the query of the current files. With dataflow, you are only connecting its ouput after it's applied its own transformations.