Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
DAFONSO
Frequent Visitor

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 want Power Bi to extract the database from a folder ( with all the excels fills) insted of a single Excel.

 

It's possible to do ?

Thank You 

1 ACCEPTED SOLUTION
some_bih
Super User
Super User

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/ 

https://goodly.co.in/dynamic-file-path-power-query/ 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






View solution in original post

6 REPLIES 6
some_bih
Super User
Super User

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/ 

https://goodly.co.in/dynamic-file-path-power-query/ 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Thank you very much @some_bih 

Fix my problem in other way, I will try to explain 

1- I put all the excels files in a folder

2- Then i add the folder to my project

3- Then i go to the power query, press mouse right click, and go to "Advanced Editor" 

4- I copy all between "Let" and "In" and close 

5- I go to the file i want to replace my source and go to the same process, but instand copy, i paste between "Let" and "in"

6- Then a close and aplay, and for me work. I stay with all the work i made and power query and now i have my source in folder. 

 

Thank you for the help !

 

some_bih
Super User
Super User

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






My situacion is case 1)

 

I try already go to on "Data source Definicion" and try to change there, but just let me change to another files, like pdf etc... And i want to change to Folder because i will recive reports every day and is easier to have on Folder to updtade alone. 

 

Sorry if i don't can clarify my ideia the best way to understand.

some_bih
Super User
Super User

Hi @DAFONSO it is possible. Check link

https://learn.microsoft.com/en-us/power-query/connectors/folder#connect-to-a-folder-from-power-query... 

Did I answer your question? Mark my post as a solution! Kudos Appreciated!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






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. 

 

 

 

Sem Título.png

 

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

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.