Forum Discussion

DAFONSO's avatar
DAFONSO
Frequent Visitor
3 years ago
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...
Data Protection
Need Help
Tips and Tricks
  • DAFONSO's avatar
    DAFONSO
    Frequent Visitor
    3 years ago

    Hi some_bih thank you for try to help.

     

    But my question is not that, i asked if is possible to change my database. Because I have now on multiple excels files, and that excel files have many power query work and i don't want to lose it. 

     

    My question is change the origin of the database to a folder, so i can update my project every day more simplify way. 

     

     

     

     

    Basically i want to change that Origin "Excel.Workbook" to "Folder.File"