Forum Discussion
Extracting data from same Excel template files
Anonymous then what you should do is get data from a folder and not an individual file in your getdata method, apply all those steps once you have done a combine (as long as they all the same, it will copy the first file format)
that way you can apply it to multiple files or if you dont want to combine them, then i suggest creating a source parameter that you can create on one and copy and paste in all, or a function
combine : https://www.youtube.com/watch?v=RAmSdxt863s
functions/parameters: https://www.youtube.com/watch?v=GgwXt4LVmsU
Anonymous then what you should do is get data from a folder and not an individual file in your getdata method, apply all those steps once you have done a combine (as long as they all the same, it will copy the first file format)
that way you can apply it to multiple files or if you dont want to combine them, then i suggest creating a source parameter that you can create on one and copy and paste in all, or a function
combine : https://www.youtube.com/watch?v=RAmSdxt863s
functions/parameters: https://www.youtube.com/watch?v=GgwXt4LVmsU
Hi vanessafvg ,
I did work the way out with the video provided (functions/parameters), it was tough but I managed it. However, I now have a tough times figuring out how to use Replace value on a row of a column that contains a date. Is there any generic way to say row 5, column 8 value to be replaced into row 5, column 2? In excel this is very straight-forward, but in Power BI not so.
Thanks for your time and help!
Anonymous you probably wouldn't do it the same way, can you filter the value you looking for? ie if column x = a then colum b sort of thing?