Forum Discussion
Solved
Change the excel workbook data source for the folder
Hi I start my project with a single excel file and i'm building and adapt all in a power query. And now i will have the same file every month, so instend i copy past for the bigger excel file, I wa...
Hi DAFONSO you need solution via parameter. Please find some of the link how to use this feature in Power query.
Hope this help
https://blog.enterprisedna.co/changing-file-location-using-a-query-parameter-in-power-bi/
Hi DAFONSO I understand two different scenarios in your case: 1) you already did transformation, create reports etc and you want simple change source from Excel to folder or 2) you did not try possible featues from link - basically creating your power bi model from start.
I would suggest, that you try (simple backup your work) if you did not do already.