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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors