cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RPA_PowerBI
New Member

How to auto set data source path in power query excel

Hello,

 

I have a macro excel sheet where i have created  some query datas , when i share the sheet with others they need to change the input data source settings to set the path for the input file. Is there a way to auto set/dynamic path setting tricks available to set the data source path???

1 ACCEPTED SOLUTION
ImkeF
Super User
Super User

Hi @RPA_PowerBI ,
this is described here: Create Dynamic File Path in Power Query - Goodly

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

1 REPLY 1
ImkeF
Super User
Super User

Hi @RPA_PowerBI ,
this is described here: Create Dynamic File Path in Power Query - Goodly

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors